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?
- 4 Answers
- 16323 Views
- L&T, I also Faced
- E-Mail Answers
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
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the important features of datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are routines in datastage? Enlist various types of routines.
What is the difference between datastage and informatica?
how to add a new records into source?
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)
What are the types of hashed files in data stage
What is quality stage?
What is the flow of loading data into fact & dimensional tables?
how can we create rank using datastage?what is the meaning of rank?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are transforms and what is the differenece between routines and transforms?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Difference between server jobs & parallel jobs?
