1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
- 5 Answers
- 12988 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
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
Describe the architecture of datastage?
How a source file is populated?
Explain entity, attribute and relationship in datastage?
What is difference between server jobs & parallel jobs?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Give an idea of system variables.
Difference between sequential file and data set?
How to perform incremental load in datastage?
How a routine is called in datastage job?
What are the different plug-ins stages used in your projects?
How you Implemented SCD Type 1 & Type 2 in your project?
Describe routines in datastage? Enlist various types of routines.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the process of killing a job in datastage?
