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. what is the procedure and whar t/r's are involved
and what is the mapping flow
Answer Posted / sree
1. drag source and targets in to mapping designer work space
2. from t/r devoloper take sequence genarato t/r,exp t/r
and router t/r.
3. in seqg t/r give startvalue 1 ,increment by 1
give netval to a newpor in exp t/r
4. drag all ports of sq to exp in addition to newport
5. in router t/r create one group name as odd
give condetion mode(newport/2)!=0
6. give from group odd to t1
and defoult to t2.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is size of u r database?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you promote a non-reusable transformation to reusable transformation?
What are the new features of informatica 9.x at the developer level?
What is a transaction control transformation?
What is informatica?
What are the different ways to implement parallel processing in informatica?
What are the mapping parameters and mapping variables?
What can we do to improve the performance of informatica aggregator transformation?
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??
Why union transformation is an active transformation?
How do you use reject loader.
What is a filter transformation?
What are the differences between a connected lookup and unconnected lookup?
What is status code in informatica?