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 |
how can u handle null values in transformer stage.
How can we improve the performance in datastage?
What are stage variables and constants?
Differentiate between Join, Merge and Lookup stage?
source contains 2 columns comes to target 4 columns how
Define oconv () and iconv () functions in datastage?
How to move data set from one server to other?what are the steps to follow to do this?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
what is .dsx files
how to identifie,is it innerjoin,leftouter join in lookup?
what is a nodemap constraint