What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Answer Posted / prabhu rathnam
Surrogate key is used to generate sequence of number from 1 to n. It increment by 1 continously and sequencly.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Explain datastage architecture?
How to perform incremental load in datastage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
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 the purpose of interprocessor stage in server jobs?
Differentiate between data file and descriptor file?
What is data partitioning?
How do you import and export the datastage jobs?
what is use of SDR function?
What is the difference between account and directory options ?
Describe routines in datastage? Enlist various types of routines.
What all the types of jobs you developed?
Lookup constraints