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
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain sessions?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Enlist few areas or real-time situations where informatica is required.
What is meant by active and passive transformation?
What is a snowflake schema?
Did u used latest transformations of 8.6.0? for what?
What is union transformation in informatica?
What are roles and groups and benefits of using them?
what are the deliverables?in your project?
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.
What all are steps in up gradation of Informatica server?
What is the benefit of partitioning a session?
What is confirmed fact in dataware housing?
In warehouses how many schemas are there?