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
- 15329 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
Differentiate between operational datastage (ods) and data warehouse?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is usage analysis in datastage?
what is use of SDR function?
What is the purpose of pivot stage?
How can we improve the performance in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is a quality stage in datastage tool?
what is flow of project?
How many types of views are there in a datastage director?
How will you move hashed file from one location to another location?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How to find value from a column in a dataset?
Define project in datastage?
