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 / abhishek kumar
in aggregator---
record(field) group by
total_record <- count(record)
router---
condition1 <- (total_record)/2
default
send to target
condition1 to target first and
default to target second.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
where to store informatica rejected data?
How we can create indexes after completing the load process?
Differences between connected and unconnected lookup?
wat are deployement groups in informatica, how it will be used for developers
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the new features of Power Center 5.0?
can anyone suggest best free Talend data integration training online
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Differentiate between a repository server and a powerhouse?
Explain lookup transformation in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
Explain lookup transformation is active in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is dimensional table?
Write the different tools in the workflow manager?