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?
Answer Posted / kpk
Pass the last key (last primary key or the last value in the
seq) as parameter.
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
How do u convert the columns to rows in datastage?
What is the difference between informatica and datastage?
Define Data Stage?
How to read the length of word in unix?
What is a folder? Difference types of stages?
How can you write parallel routines in datastage PX?
What are the difference types of stages?
in oracle target stage when we use load option and when we use upsert option?
What are routines in datastage?
What is usage analysis in datastage?
What are some different alternative commands associated with "dsjob"?
Explain usage analysis in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between the local container and shared container?