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
what is index?how it can work in informatica
How can you validate all mappings in the repository simultaneously?
can we override a native sql query within informatica? Where do we do it? How do we do it?
server hot-ws270 is connect to Repository B. What does it mean?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the components of the workflow manager?
What is data movement mode in Informatica and difference between them?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are different types of transformations available in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What do you mean by worklet?
What are the mapping parameters and mapping variables?
What is the difference between informatics 7x and 8x and what is latest version?
how tokens will generate?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.