how to remove duplicates in transformer stage by using
stage variables?one example?
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
what are the devoleper roles in real time? plz tell i am new to datastage....
What are some prerequisites for datastage?
State the difference between an operational datastage and a data warehouse?
Where do the datastage jobs get stored?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the functionalities of link partitioner and link collector?
What is the use of datastage designer?
What are transforms and what is the differenece between routines and transforms?
What is the difference between hashfile and sequential file?
What are the functionalities of link collector?
Define Merge?
Can you explain link buffering?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How many types of sorting methods are available in datastage?
What are the stages in datastage?