Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicates in transformer stage? in parallel
mode
- 6 Answers
- 17653 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
Can you define merge?
What are stage variables, derivations and constants?
what is flow of project?
What is the difference between passive stage and active stage?
How do you remove duplicate values in datastage?
What are routines in datastage?
How can we improve performance of data stage jobs?
Can you implement SCD2 using join, transformer and funnel stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is data partitioning?
what is repositery?
Define Routines and their types?
What is use Array size in datastage
Explain the datastage parallel extender (px) or enterprise edition (ee)?
how many rows sorted in sort stage by default in server jobs
