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
How do you start developing a datastage project?
What are the partitioning techniques available in link partitioner?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the types of containers in datastage?
what is the use of skid in reporting?
What is the difference between datastage and informatica?
What is difference between symmetric multiprocessing and massive parallel processing?
How to perform incremental load in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the purpose of pivot stage?
Difference between in process and inter process?
What are the functionalities of link collector?
Whats difference betweeen operational data stage (ods) and data warehouse?
Explain how a source file is populated?
Define orabulk and bcp stages?