how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 32231 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
Describe link sort?
What is the difference between server job and parallel jobs?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is ibm datastage?
What is apt_config in datastage?
What is size of a transaction and an array means in a datastage?
How to reverse the string using SQL?
Difference between data warehousing and olap?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How can you write parallel routines in datastage PX?
What are orabulk and bcp stages?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Name the third party tools that can be used in datastage?
What is the purpose of pivot stage?
what is the use of materialized view?
