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
- 10315 Views
- SLK Software, I also Faced
- E-Mail Answers
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
Define Job control?
what is flow of project?
What is a merge?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Where do the datastage jobs get stored?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the types of views in datastage director?
To see hidden files in LINIX?
Name the command line functions to import and export the DS jobs?
What is difference between join, merge and lookup stage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How can you write parallel routines in datastage PX?
Why we use surrogate key?
What is the difference between account and directory options ?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
