Interested to Buy Any Domain ? << Click Here >> for more details...
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
- 5 Answers
- 10089 Views
- SLK Software, I also Faced
- E-Mail Answers
Answer Posted / karan am
surrogate key is alternate to primary key, in order to maintain historical data.
The key source can be a state file or a database sequence. If you are using a database sequence, the sequence must be created by the Surrogate Key stage. You cannot use a sequence previously created outside of DataStage.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
EXPLAIN SCD
What are the different types of lookups in datastage?
How can we improve the performance in datastage?
What are the different plug-ins stages used in your projects?
What is datastage engine?
Can you explain tagbatch restructure operator?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How do y read Sequential file from job control?
What are the different layers in the information server architecture?
Highlight the main features of datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is difference between join, merge and lookup stage?
What is the roundrobin collector?
How do you import and export data into datastage?
