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: pls full details
- 8 Answers
- 18549 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mike
target1
src-->sq-->seq gen-->rtr--> /
\
target 2
drag the source. create an sequence generator
transformation and then pass all the data to router create
two groups in the router transformation pass it to
target...You can give the condition in the router
transformation based on your requirement. if it is like odd
and even...you can use mod function in the router
transformation.
Mod function returns 0 passit to t2 and mod function
returns 1 pass it to t1
hope this works...correct me if i was wrong
| Is This Answer Correct ? | 3 Yes | 13 No |
Post New Answer View All Answers
How to use pmcmd utility command?
On which transformations you created partitions in your project?
how to load rows into fact table in data warehouse
What is dimensional table?
Design a mapping to load a target table with the following values from the above source?
What is mapplet in informatica?
How do you load only null records into target?
Did u used latest transformations of 8.6.0? for what?
How can you generate reports in informatica?
Difference between Target-based loading and constraint-based loading?
How to load last n records of file into target table - informatica
What is an expression transformation?
What is sequence generator transformation in informatica?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to start a workflow using pmcmd command?
