What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Answer Posted / prabhu rathnam
Surrogate key is used to generate sequence of number from 1 to n. It increment by 1 continously and sequencly.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between datastage and datastage tx?
Does datastage support slowly changing dimensions ?
Name the different sorting methods in datastage.
Why we use surrogate key?
How to implement complex jobs in data stage?
Differentiate between data file and descriptor file?
how do u catch bad rows from OCI stage? And what CLI stands for?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is job control?
CHANGE CAPTURE
How to read multiple files using a single datastage job if files have the same metadata?
What are the partitioning techniques available in link partitioner?
What is the purpose of pivot stage and types of containers in datastage