How to remove duplicates in transformer stage? in parallel
mode
- 6 Answers
- 15321 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
How will you move hashed file from one location to another location?
How to read multiple files using a single datastage job if files have the same metadata?
How do you generate sequence number in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
why do u need the IOS upgradation in a FC switch
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
I have a few records just I want to store data in to targets cycling way how?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is ibm datastage flow designer?
What are the types of containers?
What is the flow of loading data into fact & dimensional tables?
How you Implemented SCD Type 1 & Type 2 in your project?
Why do we use exception activity in Datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
