sv1=inputlink sv2=if inputlink=sv3 then 1 else 0 sv3=sv1

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

Question Posted / peeyush sehgal

Answer Posted / peeyush sehgal

sv1=inputlink
sv2=if inputlink=sv3 then 1 else 0
sv3=sv1

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between operational data stage (ods) and data warehouse?

1248

What is oci?

1306

What is the purpose of pivot stage and types of containers in datastage

1042

What are the steps required to kill the job in Datastage?

1218

What is orabulk stage?

1051

What are the benefits of datastage?

1238

What are datastage sequences?

1126

What are stage variables and constants?

1151

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1748

Lookup constraints

1264

what is ds administrator used for?

1174

Can you implement SCD2 using join, transformer and funnel stage?

1559

why do u need the IOS upgradation in a FC switch

2283

How to read multiple files using a single datastage job if files have the same metadata?

1252

what is the use of materialized view?

1575