1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
- 5 Answers
- 12934 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
Answer Posted / pavan
To remove duplicates we could use Remove Duplicates Stage.
If the requirement states not to use a remove duplicates
stage, u culd use Sort stage, by setting one of its
property Allow Duplicates to false.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between server job and parallel jobs?
What are orabulk and bcp stages?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the difference between in process and inter process?
What are the processing stages?
What are the important features of datastage?
Define repository tables in datastage?
What is the purpose of interprocessor stage in server jobs?
How to find value from a column in a dataset?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Nls stands for what in datastage?
How many Key we can define in remove duplicate stage?
Is the value of staging variable stored temporarily or permanently?
