i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2.
Answer Posted / abpat2203
Add a sequence generator. Next, pass the all the data along
with that from the sequence generator into a router.
In the router, use the mod fucntion on the value incoming
from sequence generator.
If the mod fucntion returns a 0, pass it to T2 and if it
returns any other value other than 0, pass it into T1.
Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
Which development components of informatica have the highest usage?
What are the types of caches in lookup? Explain them.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How many types of sessions are there in informatica.please explain them?
Define pmcmd command?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Why sorter is an active transformation?
How to join three sources using joiner? Explain though mapping flow.
Explain the informatica workflow?
whats the logic to load the lower level of granularity of data to fact table.
I have a flat file, want to reverse the contents of the flat file
What are the guidelines to be followed while using union transformation?
What are the new features of Power Center 5.0?
What is workflow? What are the components of the workflow manager?