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
- 6580 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 |
how lookup is acting as both active and passive ? how is it possitble?
what is filelist concept in informatica
1 lac of flat fles in source how to load target at a time?
Explain about the concept of mapping parameters and variables ?
How to Join Tables my Source is having 15 table target is one?
What are the types of caches in lookup? Explain them.
How to generate sequence numbers without using the sequence generator transformation?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
Do you have to change the reject file b4 using reject loader utility.
What is junk dimention?
explain abt joiner t/r?
Can you generate sequence numbers without using the sequence generator transformation?
Teradata 
