Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of surogate key in datastage
- 3 Answers
- 9305 Views
- I also Faced
- E-Mail Answers
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 to find no.of records in sequntial file itself?
How to reverse the string using SQL?
In one project how many shared containers are created?
how can we do null handling in sequential files
how do you pass parameters in a script?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
in aggregator , how can i get the sum in readable format
How do you run datastage job from the command line?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
Explain briefly scd type2 in datastage7.5x2(parallel)
What are the partitioning techniques available in link partitioner?
What is quality stage?
Teradata 
