How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 19678 Views
- I also Faced
- E-Mail Answers
Answer Posted / davan
sq-->sort--exp--riuder--tg1--tg2
In exp V_flag=iif(empno=p_empno,v_flag+1,1)--variable port
p_empno=empno--variable port
0_flag=v_flag--output port
In rouder o_flag>1 one target,default one target
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
design of staging area?
How you can differentiate between connected lookup and unconnected lookup?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the tuning techniques you applied during your last project
Tell me about Propagate functions in informatica
Partition, what happens if the specified key range is shorter and longer
What are the different clients of powercenter?
Explain sessions?
What are different types of transformations available in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to elaborate tracing level?
What is substr in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
