Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7172 Views
- Wipro, I also Faced
- E-Mail Answers
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
What are the settings that you use to configure the joiner transformation?
How can repository reports be accessed without sql or other transformations?
How can you validate all mappings in the repository simultaneously?
If informatica has its scheduler why using third party scheduler?
What is a mapplet/worklet in informatica?
Explain your project of banking domian.
What are the differences between oltp and olap?
Differentiate between a repository server and a powerhouse?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is INFORMATICA TESTING process
Which transformation should we use to normalise the COBOL and relational sources?
What do think which one is the better joiner or look up?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the need of an ETL tool?
