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
- 7856 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mari ilavarasi
Using router transformation we can send half of the records
in one target and rest of the records will be inserted into
another target based on conditions.
| Is This Answer Correct ? | 6 Yes | 3 No |
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
What are the types of presistent cache in look up tr.
What happens if the info. Server doesn't find the session parameter in the parameter file?
what is the size of u r source(like file or table)?
How can you run a session without using server manager?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is a standalone command task?
How does a sorter cache works?
What are the different types of Type2 dimension maping?
diffrence between command task and control task
What are the different versions of informatica?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
Teradata 
