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: pls full details
- 8 Answers
- 15902 Views
- L&T, TCS, UnitedHealth Group, Wipro, 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 ? | 9 Yes | 7 No |
Post New Answer View All Answers
What is the status code in stored procedure transformation?
What are junk dimensions?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Separate from an archive server and a powerhouse?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is meant by incremental aggregation?
Enlist the various types of transformations.
what is size of u r database?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How big was your fact table
4 yrs etl devloper roles and responsibilities?any body give solutions
What is a router transformation?
What is an active transformation?
How do you load only null records into target?
What is meant by a domain?
