how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 31709 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
what is ds administrator used for?
Define oconv () and iconv () functions in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Enlist various types of routines in datastage.
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the difference between datastage and datastage tx?
What is the command line function to import and export the ds jobs?
Difference between server jobs & parallel jobs?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Explain Quality stage?
Explain entity, attribute and relationship in datastage?
What is the purpose of pivot stage?
Does datastage support slowly changing dimensions ?
what is the use of surogate key in datastage
