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
client know skid info?
What is the difference between the local container and shared container?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the different kinds of views available in a datastage director?
Differentiate between datastage and informatica?
how to implement scd2 in datastage 7.5 with lookup stage
What is the difference between informatica and datastage?
What is the command line function to import and export the ds jobs?
what is the difference between == and eq in UNIX shell scripting?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How to clean the datastage repository?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
State the difference between an operational datastage and a data warehouse?
If you want to use a same piece of code in different jobs, how will you achieve this?
Explain entity, attribute and relationship in datastage?