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
Difference between Target-based loading and constraint-based loading?
Could you explain what is enterprise data warehouse?
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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are pre and post-session shell commands?
How can we create index after completion of load process?
What do you mean by blocking transformation?
What do you mean by worklet?
Does an informatica transformation support only aggregate expressions?
What is decode in static cache?
What is a connected transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Performance tuning in UNIX for informatica mappings?
In informatics server which files are created during the session rums?
What are the designer tools for creating transformations?