what is the use of surogate key in datastage
- 3 Answers
- 8229 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 |
What is the importance of the exception activity in datastage?
I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
Explain entity, attribute and relationship in datastage?
Explain how a source file is populated?
how to find no.of records in sequntial file itself?
How can you join flat file, oracle as a sources?
Why do you need stage variables?
what is main difference between change capture and change apply stages
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the benefits of datastage?
what is normalization and denormalization
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Teradata 
