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
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is a folder? Difference types of stages?
If you want to use a same piece of code in different jobs, how will you achieve this?
Differentiate between datastage and informatica?
What are constraints and derivations?
in oracle target stage when we use load option and when we use upsert option?
What is the difference between account and directory options ?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How to clean the datastage repository?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Nls stands for what in datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Differentiate between hash file and sequential file?
What are the types of views in datastage director?
What is size of a transaction and an array means in a datastage?