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
What is domain and gateway node?
Can we create multiple integration service on single repository?
What is joiner change?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How many dimensions are there in informatica?
What do you mean by blocking transformation?
What is blocking transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is source qualifier transformation in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Under what conditions selecting sorted input in aggregator will still not boost session performance?
can we override a native sql query within informatica? Where do we do it?
What is a code page?
What's the layout of parameter file (what does a parameter file contain?)?