Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 9 Answers
- 13031 Views
- IBM, I also Faced
- E-Mail Answers
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 does command task mean?
Why sorter is an active transformation?
What is the command used to run a batch?
What is Session and Batches?
What are the types of caches in lookup? Explain them.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Under what condition selecting sorted input in aggregator may fail the session?
What all join we can perform in LOOKUP transformation?
Differentiate between a database and data warehouse?
How can one identify whether mapping is correct or not without connecting session?
What are the different types of transformation available in informatica.
Sequence generator, when you move from develoment to production how will you reset
Write the unconnected lookup syntax?
How do you convert single row from source into three rows into target?
What is joiner change?
