Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of surogate key in datastage
- 3 Answers
- 9486 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 |
Have you used Unstructured data?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
How to read the length of word in unix?
What is the difference between account and directory options ?
Differentiate between data file and descriptor file?
What could be a data source system?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
EXPLAIN SCD
How one source columns or rows to be loaded in to two different tables?
How to move data set from one server to other?what are the steps to follow to do this?
How many types of views are there in a datastage director?
what is Audit table?Have u use audit table in ur project?
Teradata 
