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
client know skid info?
How do you import and export the datastage jobs?
What is use Array size in datastage
What is ibm datastage flow designer?
What is meta stage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the different common services in datastage?
What a datastage macro?
How to implement complex jobs in data stage?
what are the devoleper roles in real time? plz tell i am new to datastage....
Define Routines and their types?
What is merge stage?
What are the functionalities of link partitioner?
How can we improve performance of data stage jobs?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?