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
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Can you explain kafka connector?
What is the difference between datastage and datastage tx?
What are the types of views in datastage director?
why do u need the IOS upgradation in a FC switch
If you want to use a same piece of code in different jobs, how will you achieve this?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Difference between sequential file and data set?
what are the devoleper roles in real time? plz tell i am new to datastage....
Explain datastage architecture?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the difference between datastage and informatica?
EXPLAIN SCD
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the different kinds of views available in a datastage director?