Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
- 5 Answers
- 15143 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
What are orabulk and bcp stages?
What is the difference between an operational datastage and a data warehouse?
Is the value of staging variable stored temporarily or permanently?
What is staging variable?
Describe link sort?
what is the use of skid in reporting?
If you want to use a same piece of code in different jobs, how will you achieve this?
How complex jobs are implemented in datstage to improve performance?
What all are the different way to run a job?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Highlight the main features of datastage?
How can one find bugs in job sequence?
Define orabulk and bcp stages?
how many rows sorted in sort stage by default in server jobs
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
