how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 31066 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 run a sequential file stage in parallel if the stage is used on the TARGET side
What is a quality stage in datastage tool?
Define oconv () and iconv () functions in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
project Steps,hits, Project level HArd things,Solved methods?
whom do you report?
How many Key we can define in remove duplicate stage?
What are the functionalities of link collector?
What are the different options associated with dsjob command?
What is the different type of jobs in datastage?
How will you move hashed file from one location to another location?
What are the enhancements made in datastage 7.5 compare with 7.0?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the purpose of interprocessor stage in server jobs?
