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.
can any tell me procedure.
Answer Posted / mari ilavarasi
Using router transformation we can send half of the records
in one target and rest of the records will be inserted into
another target based on conditions.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
How can informatica be used for an organization?
When do you use sql override in a lookup transformation?
How do you use reject loader.
What if the source is a flat-file?
How to load last n records of file into target table - informatica
whats the logic to load the lower level of granularity of data to fact table.
Write the advantages of partitioning a session?
What is a difference between complete, stop and abort?
explain one complex mapping with logic? sales project?
What are the different clients of powercenter?
What is option by which we can run all the sessions in a batch simultaneously?
What is the use of code page?
what is song in infrmatica...?
Write the prerequisite tasks to achieve the session partition?