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


Please Help Members By Posting Answers For Below Questions

How to create the source and target database connections in server manager?

634


How to create Target definition for flat files?

755


design of staging area?

1592


Briefly define a session task?

592


What is dimensional table?

624






How to extract the informatica rejected data?

757


What is an active transformation?

648


How many numbers of sessions can one group in batches?

625


What is the need of an ETL tool?

644


How can informatica be used for an organization?

653


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1327


What are the various types of transformation?

646


What are the reusable transformations?

700


What is a pre-defined event and user-defined event?

579


Which means the first record should come as last record and last record should come as first record and load into the target file?

610