Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicates in transformer stage? in parallel
mode
- 6 Answers
- 17425 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
What is the sortmerge collector?
What are the types of containers and how to create them?
Difference between server jobs & parallel jobs?
What are the different options associated with dsjob command?
Differentiate between validated and Compiled in the Datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the types of views in datastage director?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Name the different sorting methods in datastage.
What are the some differences between 7.x and 8.x version of datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How can one find bugs in job sequence?
What is quality stage?
CHANGE CAPTURE
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
