what is the use of surogate key in datastage
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pavani
we used the surrogate key for the sequence(for files in order)
ex we save one dummy value in some text file that dummy
value is surrogate key value when ever we are using the
surrogate stage we have to use that file for sequence order
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shiva
WE DONT USE PRODUCTION KEYs IN OUR DW, SO WE GENERATE OUR
OWN KEYS TO IMPLIMENT DW USING THIS SUROGATE KEY.
Is This Answer Correct ? | 2 Yes | 1 No |
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the different type of jobs in datastage?
in oracle target stage when we use load option and when we use upsert option?
why do u need the IOS upgradation in a FC switch
Have you used Unstructured data?
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
How you can fix the truncated data error in datastage?
Name the third party tools that can be used in datastage?
Why fact table is in normal form?
what is the use of surogate key in datastage
What is a quality stage?