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
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
Explain the different lookup methods used in informatica?
What is informatica? Why do we need it?
What are the different types of olap? Give an example?
What is expression transformation?
can anyone explain me about retail domain project in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is data movement mode in Informatica and difference between them?
Define sessions in informatica etl?
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?
What differs when we choose the sorted input for aggregator transformation?
Different circumstance which drives informatica server to expel records?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is xml source qualifier transformation in informatica?
what is mean by complex business rule ?