how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 32255 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
How do you import and export the datastage jobs?
What is the difference between account and directory options ?
What are the stages in datastage?
What is the difference between in process and inter process?
What is quality stage?
What a datastage macro?
What is "fatal error/rdbms code 3996" error?
What is the precedence of stage variables,derivations, and constraints?
Where do the datastage jobs get stored?
How do you import and export data into datastage?
What is difference between join, merge and lookup stage?
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
Highlight the main features of datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the functionalities of link partitioner and link collector?
