i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details
Answer Posted / babu
Frnds small change in the above answer..
i.e: GRP1 :O_SEQ1>=O_SEQ2 ,GRP2: O_SEQ1<O_SEQ2
OR
GRP1 :O_SEQ1>O_SEQ2 ,GRP2: O_SEQ1<=O_SEQ2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to update source definition?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How can we use mapping variables in informatica? Where do we use them?
Mention few advantages of router transformation over filter transformation.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Clarify the utilization of aggregator cache record?
Explain lookup transformation source types in informatica
Please let me know how to make encryption and decryption with example?
Explain the difference between mapping parameter and mapping variable?
Explain sessions and how many types of sessions are there?
define galaxy repository in informatica
Under which circumstances, informatica server creates reject files?
What will be the approach?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
can we override a native sql query within informatica? How do we do it?