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
- 7747 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
Explain dynamic target flat file name generation in informatica
is it possible to index the data in cache of lkp transformation ?
Parameter and variable differences
What is informatica metadata and where is it stored?
What is a dimensional model?
How to go to the older version for a mapping?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the types of data warehouses?
Where do we use mapping variables in informatica?
Explain the scenario which compels informatica server to reject files?
What is native users?
Explain Dataware house architecture .how data flow from intial to end?
Explain the shared cache and re-cache?
Explain sessions. Explain how batches are used to combine executions?
What is domain and gateway node?
