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
- 7701 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
What is a sequence generator transformation?
How can we delete duplicate rows from flat files?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to generate sequence numbers?
What is the difference between STOP and ABORT options in Workflow Monitor?
Mention few power centre client applications with their basic purpose?
explain one complex mapping with logic? sales project?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to create a non-reusable instance of reusable transformations?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Differentiate between sessions and batches?
Is it possible to create multiple domains on a single Informatica server?
How to do unit testing in informatica? How to load data in informatica ?
What are the different versions of informatica?
How to differentiate between the active and passive transformations?
