Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of surogate key in datastage
- 3 Answers
- 9581 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 define satge variables in transformer stage
What steps should be taken to improve Datastage jobs?
Lookup constraints
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
What is the difference between the local container and shared container?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is audit table?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
What is the difference between validated and compiled in the datastage?
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
Teradata 
