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

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1730


Explain the different lookup methods used in informatica?

793


What is informatica? Why do we need it?

844


What are the different types of olap? Give an example?

761


What is expression transformation?

827


can anyone explain me about retail domain project in informatica?

7693


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1833


What is data movement mode in Informatica and difference between them?

855


Define sessions in informatica etl?

780


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

978


What differs when we choose the sorted input for aggregator transformation?

799


Different circumstance which drives informatica server to expel records?

733


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

817


What is xml source qualifier transformation in informatica?

951


what is mean by complex business rule ?

1900