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
Define data aggregation?
Why do we use exception activity in Datastage?
How many types of sorting methods are available in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the types of hashed files in data stage
What are data elements?
What is ds designer?
What are datastage sequences?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
State the difference between an operational datastage and a data warehouse?
What is a merge?
How to read multiple files using a single datastage job if files have the same metadata?
What is meta stage?
Define repository tables in datastage?
What is the difference between operational data stage (ods) and data warehouse?