Interested to Buy Any Domain ? << Click Here >> for more details...
how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 33911 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / amit
using hash partition technique, we can bring duplicate data(based on key columns) in one partition. Then in stage constraints filter out data with setting @inrownum = 1.
This will remove duplicate in transformer stage.
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the precedence of stage variables,derivations, and constraints?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the difference types of stages?
What is the purpose of pivot stage and types of containers in datastage
What is staging variable?
client know skid info?
What is difference between symmetric multiprocessing and massive parallel processing?
Is the value of staging variable stored temporarily or permanently?
How you Implemented SCD Type 1 & Type 2 in your project?
how to sort two columns in single job in datastage.
What is data partitioning?
Describe the main features of datastage?
How to clean the datastage repository?
What are the main features of datastage?
