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
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
Can we create two repositories on same database instance in oracle?
What are the transformations that are not supported in mapplet?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How do you load only null records into target?
What are the mapping parameters and mapping variables?
What is meant by target load plan?
What is workflow manager?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a passive transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to differentiate between the active and passive transformations?
What is deployment group?