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
Explain the types of lookup transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the use of an aggregator cache file?
explain one complex mapping with logic? sales project?
How can we store previous session logs?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What if the source is a flat-file?
what is size of u r database?
How might one distinguish in the case of mapping is right or not without associating session?
Is stop and abort are same in informatica?
What is informatica worklet?
What is workflow? What are the components of workflow manager?
What is parallel processing in informatica?
What is an active transformation?
How to improve the performance of a session using sorter transformation?