How to extract original records at one target & Duplicate
records at one target?
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
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Why do you use Mapping Parameter and mapping variable?
How to open an older version of an object in the workspace?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the new features of informatica 9.x developer?
What is dimensional table?
What is informatica?
What are the types of lookup transformation?
What does cheating measurement mean?
How to use pmcmd utility command?
What are the advantages of using informatica as an etl tool over teradata?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Which development components of informatica have the highest usage?
What are Dimensional table?
What is complex mapping?