how to remove duplicates in transformer stage by using
stage variables?one example?
Answer Posted / ds
In Stage variable:
stage_variable3 <map> stage_variable1
if column=stage_variable1 than 0 else 1 <map>
stage_variable2
column <map> stage_variable3
Put stage_variable2 as constrain to target stage.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
how to export or import the jobs in .ISX file
What are orabulk and bcp stages?
State the difference between an operational datastage and a data warehouse?
how many rows sorted in sort stage by default in server jobs
What are the differences between datastage and informatica?
Explain entity, attribute and relationship in datastage?
What are routines in datastage? Enlist various types of routines.
How a server job can be converted to a parallel job?
What are the primary usages of datastage tool?
What is the difference between Datastage 7.5 and 7.0?
Which warehouse using in your datawarehouse
What is aggtorec restructure operator?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the difference between datastage and informatica?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS