suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
Answer Posted / sarat
Method Automated : Use an Unconnected lookup to count the SRC no. of records, and use it in the RTR.
Method Manual : Check COUNT(*) manually and use it in RTR( Not appreciate)
If Agg is used, one record gets loaded in one table only
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between informatica6.1 and infomatica7.1
How identifying bottlenecks in various components of informatica and resolving them?
What are data-driven sessions?
What is the function of look up transformation?
Difference between Target-based loading and constraint-based loading?
How will the document be delivered to me?
What are the features of complex mapping?
Describe an informatica powercenter?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How are indexes created after completing the load process?
What is expression transformation?
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?
explain one complex mapping with logic? sales project?