Surrogate Key generation

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

Thanks Cyril

[Anonymous]

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.

[Anonymous]

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!