Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicates in transformer stage? in parallel
mode
- 6 Answers
- 17129 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 explain link buffering?
What is oci?
What is usage analysis in datastage?
What are the types of hashed files in data stage
How do u convert the columns to rows in datastage?
How do you reject records in a transformer?
What is the difference between odbc and drs stage?
what is use of SDR function?
How do y read Sequential file from job control?
What are the types of containers and how to create them?
What are routines in datastage? Enlist various types of routines.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How will you move hashed file from one location to another location?
How you can fix the truncated data error in datastage?
How do you remove duplicate values in datastage?
