tag:blogger.com,1999:blog-6266231010760265271.post3917425775925196131..comments2024-03-29T01:19:51.547-04:00Comments on Bekwam Blog: Updating a Table with the Talend Open Studio ELT ComponentsCarlhttp://www.blogger.com/profile/15013889141640529637noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-6266231010760265271.post-73590742931039388882020-06-16T10:41:18.798-04:002020-06-16T10:41:18.798-04:00Nice information, this is will helpfull a lot, Tha...Nice information, this is will helpfull a lot, Thank for sharing, Keep do posting i like to follow this <a href="https://onlineitguru.com/informatica-online-training-placement.html" rel="nofollow">informatica online training</a><br /><a href="https://onlineitguru.com/informatica-online-training-placement.html" rel="nofollow">informatica online course</a><br /><a href="https://onlineitguru.com/informatica-online-training-placement.html" rel="nofollow">informatica bdm training</a><br /><a href="https://onlineitguru.com/informatica-online-training-placement.html" rel="nofollow">informatica developer training</a><br /><a href="https://onlineitguru.com/informatica-online-training-placement.html" rel="nofollow">informatica training</a><br /><a href="https://onlineitguru.com/informatica-online-training-placement.html" rel="nofollow">informatica course</a>Anonymoushttps://www.blogger.com/profile/07884455647499178737noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-22961248638025341222015-08-04T08:03:42.303-04:002015-08-04T08:03:42.303-04:00It's been a few years and I don't recall s...It's been a few years and I don't recall seeing these components producing SQL as you expect. The screenshot "An Update Statement..." indicates that I got the same generated SQL as you did. My example deals with a single field and doesn't have an out where clause, but you can see that the single field contains a subquery.Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-61163740310022268722015-08-03T18:19:01.513-04:002015-08-03T18:19:01.513-04:00Thank you, Carl. This post is very useful, nice wo...Thank you, Carl. This post is very useful, nice work you're doing with this blog!<br /><br />Unfortunately I wasn't able to follow these steps with SQL Server, because the ELT components are generating a command like this:<br /><br />UPDATE mytable alias_different_table_name <br />SET attr1 = (SELECT attr1 FROM source_table ... INNER JOIN ...)<br />attr2 = (SELECT attr2 FROM source_table ... INNER JOIN ...)<br />WHERE ...<br /><br />And the expected syntax would be:<br /><br />UPDATE mytable<br />SET attr1 = A.attr1<br />attr2 = A.attr2<br />FROM source_table A<br />INNER JOIN ...<br />WHERE ...<br /><br />I don't know if the syntax above is the only one correct, but I tried both methods manually and only the second option had success (I think that is more optimized, also). The first option only worked without the alias defined in the output component and before the 'SET' word.<br /><br />Now I'm inserting all the data in a temporary table and then I use a tSQLTemplateMerge component to update/insert the target table.<br /><br />Best regards,<br />AnselmoAnselmohttps://www.blogger.com/profile/04865705220235300842noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-39553370146094451762015-08-03T18:14:08.456-04:002015-08-03T18:14:08.456-04:00This comment has been removed by the author.Anselmohttps://www.blogger.com/profile/04865705220235300842noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-19568804756531389072012-08-16T22:55:52.440-04:002012-08-16T22:55:52.440-04:00Thanks Carl,
I have tried to use tELTOracle compo...Thanks Carl,<br /><br />I have tried to use tELTOracle components and getting errors as all my source and targets are oracle tables only and having huge data. That's reason i plan to use ELT components. and it's straight forward, for dimensions just update and insert(type1) some look ups and aggregations for the fact tables.<br /><br />The error is that target schema is not same as the input schema. <br /><br />could you please advise me on this, like for performance wise which component would better. i thought of using ELT Components but not able to resolve the error.srinihttps://www.blogger.com/profile/07425024487187856544noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-83959543537410574882012-08-16T22:03:13.868-04:002012-08-16T22:03:13.868-04:00Hi,
This is a scenario where a large flat data fi...Hi,<br /><br />This is a scenario where a large flat data file is being loaded into two normalized tables, BUSINESS and CONTACT. This process removes a repeating group "BUSINESS" that is repeated for some of the CONTACTS.<br /><br />The loading is done in two stages (you're seeing the second in this post). The first stage quickly loads the text file into two tables using a bulk loading component. However, the linkage between the two tables (BUSINESS and CONTACT) is broken.<br /><br />So, a lookup table matching two business keys in the source data: BUSINESS_NAME and PRIMARY_CONTACT_EMAIL. The second stage of processing -- shown in this post -- is an update statement working within the database for efficiency.<br /><br />You can avoid the multi-stage processing on smaller data sets, opting for something like a getLastId component chained together with the output component. There are examples of this on the blog. But this may not be the most efficient processing since it can't be done with a bulk load since batching must be turned off.Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-77086131868490929222012-08-16T10:00:31.191-04:002012-08-16T10:00:31.191-04:00Hi,
For above example do all the tables in the s...Hi, <br /><br />For above example do all the tables in the same schema?srinihttps://www.blogger.com/profile/07425024487187856544noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-10659127635243556222012-03-25T18:49:15.203-04:002012-03-25T18:49:15.203-04:00Your post is helpful with me, thanks for your guid...Your post is helpful with me, thanks for your guide.dqvn2002https://www.blogger.com/profile/02189076127656837059noreply@blogger.com