topic Delete and insert in a SQL Server imported data from positional file in Talend Studio

Delete and insert in a SQL Server imported data from positional file

_AnonymousUser — Thu, 20 Sep 2012 17:44:00 GMT

Hi all,
I'm a newbie about Talend DI and I would like perform these following tasks:
- import a positional file
- truncate destination table
- transform imported clean
- insert trasformed data into the destination table.
I'm reading the Talend DI User Guide, but actually I dont understand how can i perform this easy job.
Does anyone can notice me any image or simple tutorial useful to my training?
Thanks in advance

Re: Delete and insert in a SQL Server imported data from positional file

_AnonymousUser — Fri, 21 Sep 2012 10:27:33 GMT

Hi,
I need only a simple example to understand talend machanisms.
Does anybody can help me?

Re: Delete and insert in a SQL Server imported data from positional file

janhess — Fri, 21 Sep 2012 11:16:18 GMT

Try looking at the tutorials and the examples provided with Talend. This is very fundemental stuff.

Re: Delete and insert in a SQL Server imported data from positional file

Anonymous — Fri, 21 Sep 2012 11:34:04 GMT

Hi, Rosanero4Ever
For your tasks, we design a job(see pic): tMysqlRow(onSubjectok)-->in.txt(main)-->tMysqloutput-->tLogRow. We set the in.txt as a positional file and the pattern is "7,9,*" , for example:
Id Name age
1 Mike 22
2 John 33
This job can meet your 4 needs:
- import a positional file
- truncate destination table
- transform imported clean
- insert trasformed data into the destination table.
And in the component tMysqlRow, the query is

"truncate table_name"

.

Best Regards
Sabrina

Re: Delete and insert in a SQL Server imported data from positional file

Anonymous — Fri, 21 Sep 2012 12:07:42 GMT

Suggest you to check out the following link http://www.talend.com/resources/documentation.php download the appropriate document and start with it.
Best of luck!!!
--
Regards,
Vinod

Re: Delete and insert in a SQL Server imported data from positional file

Rosanero4Ever — Fri, 21 Sep 2012 13:09:10 GMT

thank you very much for your kindness.
I'm studying a lot in this moment but I'm fighting with many difficulties (I'm at the second day of using Talend)
The learning curve is hard (for me...) but Talend may be a perfect tool for my work (my job is design dw and etl and at today i wrote only a lot of code for sql scripts)
Thanks again in advance for my future help request

Re: Delete and insert in a SQL Server imported data from positional file

janhess — Fri, 21 Sep 2012 15:18:01 GMT

Hi, Rosanero4Ever
For your tasks, we design a job(see pic): tMysqlRow(onSubjectok)-->in.txt(main)-->tMysqloutput-->tLogRow. We set the in.txt as a positional file and the pattern is "7,9,*" , for example:
Id Name age
1 Mike 22
2 John 33
This job can meet your 4 needs:
- import a positional file
- truncate destination table
- transform imported clean
- insert trasformed data into the destination table.
And in the component tMysqlRow, the query is
"truncate table_name"
.

Best Regards
Sabrina

Why would you use tMysqlRow to truncate a table when it can be done in tMysqlOutput?

Re: Delete and insert in a SQL Server imported data from positional file

janhess — Fri, 21 Sep 2012 15:26:33 GMT

See https://community.talend.com/t5/Design-and-Development/update-insert-AND-delete-old-rows/td-p/100314 for an image of database insert/update/delete.