Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table.
can any tell me procedure.
- 2 Answers
- 7973 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / jay
SCR-->SQ-->AGGR-----
| |
| v TRG 1
--------->RTR--> /
/ \
SEQ TRG 2
First get the count of records using Aggr t/r
and use this result in router t/r and have
router condition as SEQ < (Count / 2) for TRG 1
and default for TRG 2
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
How to extract sap data using informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
what is index?how it can work in informatica
In which transformation you cannot drag ports into it?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Do you find any difficulty while working with flat files as source and target?
Define sessions in informatica etl?
How can we improve session performance in aggregator transformation?
Explain how to import oracle sequence into informatica?
What is union transformation in informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to generate sequence numbers?
What is Index Caches size?
What do you mean by filter transformation?
What is confirmed fact in dataware housing?
