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
How would you copy the content of one repository to another repository?
Why do you use Mapping Parameter and mapping variable?
update strategy transformation in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the differences between joiner transformation and source qualifier transformation?
Explain your project of banking domian.
Explain lookup transformation is active in informatica
Tell me about MD5 functions in informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
can you please explain me pre session and post session options?
Explain the code page compatibility?
What is the commit type if you have a transaction control transformation in the mapping?
how many types of dimensions are available in informatica?