how to remove duplicates in transformer stage by using
stage variables?one example?

Answer Posted / ds

In Stage variable:

stage_variable3 <map> stage_variable1
if column=stage_variable1 than 0 else 1 <map>
stage_variable2
column <map> stage_variable3

Put stage_variable2 as constrain to target stage.

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between datastage and datastage tx?

609


What are the job parameters?

721


Where the datastage stored his repository?

630


What is the difference between orabulk and bcp stages?

588


What are some prerequisites for datastage?

623






What is "fatal error/rdbms code 3996" error?

670


Where do you see different stages in the designer?

644


What is a merge in datastage?

780


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3389


Why do we use link partitioner and link collector in datastage?

689


Define meta stage?

792


How complex jobs are implemented in datstage to improve performance?

606


Name the different sorting methods in datastage.

621


How many types of hash files are there?

620


How can you write parallel routines in datastage PX?

630