Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / navin
DW is for to maintain historical & current data.
if use Natural key as primary key in DW we can't maintain
history.so we need a physical key in DW i.e is generated by
ETL developer .In DW we have develop a key called surrogate
key.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Why we use surrogate key?
Why do you need stage variables?
What is aggtorec restructure operator?
why do u need the IOS upgradation in a FC switch
how to write server Routine coding?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How do you run datastage job from the command line?
options available in sequence job to run,validate?
Can you explain players in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How to reverse the string using unix?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between orabulk and bcp stages?
How and where you used hash file?
