Surrogate Key generation

One Star

Surrogate Key generation

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.
Employee

Re: Surrogate Key generation

Hi Madhava,
You can generate "surrogate keys" using the tDBSCD 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.
One Star

Re: Surrogate Key generation

Thanks Cyril
One Star

Re: Surrogate Key generation

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.