Interested to Buy Any Domain ? << Click Here >> for more details...
how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 33338 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / prasad
take two stage variables
sV1: Input_column
sV2: if Input_column = sV1 then 0 else 1
and put 'sV1=1' as constraint
Plz correct me, If am wrong.....
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
how to implement scd2 in datastage 7.5 with lookup stage
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is a folder? Difference types of stages?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between passive stage and active stage?
How will you move hashed file from one location to another location?
What is job control?
Why do you need stage variables?
What is the difference between an operational datastage and a data warehouse?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the importance of the exception activity in datastage?
Can you explain tagbatch restructure operator?
What is ibm datastage?
Differentiate between operational datastage (ods) and data warehouse?
What are stage variables, derivations and constants?
