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 / suresh
surrogate key is alternate to primary key,it allows duplicates also,while maintain the hystorical data we use surrogate key
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Differentiate between odbc and drs stage?
State the difference between an operational datastage and a data warehouse?
What are the some differences between 7.x and 8.x version of 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 is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Describe routines in datastage? Enlist various types of routines.
Describe link sort?
Name the different sorting methods in datastage.
What is job control?
What is a datastage job?
What are the functionalities of link partitioner?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is ds designer?
What is a quality stage in datastage tool?
What are the functionalities of link partitioner and link collector?