Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicates in transformer stage? in parallel
mode
- 6 Answers
- 17458 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / praveen sarva
STEP 1) TRANSFORMER STAGE PROPERTIES--> ADVANCED -->
EXECUTION MODE ---> PARLLEL
STEP 2) TRANSFORMER STAGE PROPERTIES --> INPUT -->
PARTITIONING--> PARTITION TYPE --> HASH ---> ENABLE SORT ---
> ENABLE UNIQUE
Simple u will get non duplicate records....
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is "fatal error/rdbms code 3996" error?
Differentiate between hash file and sequential file?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Differentiate between datastage and datastage tx?
What are constraints and derivations?
Can you define merge?
What is the sortmerge collector?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is difference between server jobs & parallel jobs?
What is the difference between operational data stage (ods) and data warehouse?
How do u convert the columns to rows in datastage?
Differentiate between validated and Compiled in the Datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are stage variables?
