Friday, April 15, 2011
Surrogate Key in Datastage
And in natural key, it may have alphanumeric composite key but the surrogate is
always single numeric key.
Surrogate key is used to generate key columns, for which characteristics can be
specified. The surrogate key generates sequential incremental and unique integers for a
provided start point. It can have a single input and a single output link.
If you know Better Answer for Above Question Comment below to Answer.
Change Capture Stage is used to capture the changes between two sources based on the change code. Change Code is the Code generated w...
Some times we get the data as below Customers 1,tommy,2000 2,sam,2300 3,margaret,2000 4,pinky,1900 5,sheela,2000 Take Job Design...