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
- 15122 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 the devoleper roles in real time? plz tell i am new to datastage....
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
EXPLAIN SCD
Can you explain link buffering?
What is ds designer?
How to reverse the string using SQL?
root tree will find which is server job and which is parallel job?
Explain the importance of surrogate key in data warehousing?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Define Data Stage?
What are the stages in datastage?
Why do you need stage variables?
sed,awk,head
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
what is the use of skid in reporting?
