Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicates in transformer stage? in parallel
mode
- 6 Answers
- 17646 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / prasad
Take 2 Stage variables in transformer stage
sV1 =Column_Name
sV2 =if Column_Name=sV1 Then 0 Else 1
put it constraint sV2=1 (only will get unique records)
if u want duplicates sV2=0
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Give an idea of system variables.
how to write server Routine coding?
How a server job can be converted to a parallel job?
How rejected rows are managed in datastage?
Describe stream connector?
How you Implemented SCD Type 1 & Type 2 in your project?
What is datastage?
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 is the difference between hashfile and sequential file?
Difference between server jobs & parallel jobs?
What are the primary usages of datastage tool?
Distinguish between informatica & datastage. Which one would you choose and why?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the purpose of pivot stage?
How to RD using transformer?
