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
- 7739 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 |
Implementation methodology
What is meant by active and passive transformation?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
how to load only the first and last record of a flat file into the target?
What are the types of caches in lookup? Explain them.
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
Difference between Target-based loading and constraint-based loading?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to update or delete the rows in a target, which do not have key fields?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
Which is the t/r that builts only single cache memory?
Can you generate sequence numbers without using the sequence generator transformation?
Teradata 
