1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
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
Enlist various types of routines in datastage.
What is process model?
What is the command line function to import and export the ds jobs?
Define orabulk and bcp stages?
Name the command line functions to import and export the DS jobs?
How do y read Sequential file from job control?
What is the precedence of stage variables,derivations, and constraints?
What are the steps needed to create a simple basic datastage job?
What a datastage macro?
Nls stands for what in datastage?
What is quality stage?
How many types of views are there in a datastage director?
What are stage variables and constants?
What is active and passive stage?
How can we improve performance of data stage jobs?