1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
Answer Posted / kiran
IN surrogate key generator stage set the block size to 2
with initial value as 2, it will increment the surrogates
by 2 and will get you even numbers. I don't think in any
real world scenario you would do this as it violates
surrogate key concept. I wish the interviewer knew this
before he/she asked you.
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What all the types of jobs you developed?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How do you generate sequence number in datastage?
Why do you need stage variables?
What are the different types of lookups in datastage?
What is the purpose of pivot stage?
Explain the importance of surrogate key in data warehousing?
What is a merge in datastage?
Describe link sort?
How do you schedule or monitoring the job?
What is the process of killing a job in datastage?
What is the precedence of stage variables,derivations, and constraints?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Whats difference betweeen operational data stage (ods) and data warehouse?