topic Re: Surrogate Key generation in Talend Studio

Surrogate Key generation

Anonymous — Sat, 16 Nov 2024 13:01:31 GMT

Hi,
How to generate surrogate Key for dimensions.Any Examples is available plz post that URL or document.
my scenario is when first time dimension is loaded into the warehouse surrogate key generate unique number to each record in that dimension.Once again i loaded the same dimension into warehouse with same data in this situation how the key is generated.
Thanks in Advance.

Re: Surrogate Key generation

Anonymous — Tue, 22 Mar 2011 13:08:03 GMT

Hi Madhava,
You can generate "surrogate keys" using the t DBSCD components. Have a look at the reference guide to find scenarii using those components (cf. tMySQLSCD).
For basic primary key generation, you can also have a look at this thread ( http://www.talendforge.org/forum/viewtopic.php?pid=52159), showing how to use the Numeric.Sequence routine.
Regards,
Cyril.

Re: Surrogate Key generation

Anonymous — Tue, 22 Mar 2011 14:36:03 GMT

Thanks Cyril

Re: Surrogate Key generation

Anonymous — Thu, 24 Mar 2011 06:10:00 GMT

Hi,
When i use multiple data sources,i need to join them and put in one table.
for example i have taken 3 tables in my database each contain one common column i need to map these columns to target table. Is there any option to create a table dynamically i talend open studio.When we map to the target database it shows only empty,i.e we need to add columns or is there any option to create a table dynamically..
Thanks.

Re: Surrogate Key generation

Anonymous — Tue, 09 Jul 2019 15:23:48 GMT

Hi Madhav, For Generating Surrogate key in Talend refer the following blog

https://www.learningsutras.net/post/tech-generating-surrogate-key-in-talend

Thank you.

Hope this help!