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
Differentiate between reusable transformation and mapplet.
What is rank transformation?
What are pre and post-session shell commands?
Explain the tuning lookup transformation - informatica
What is meant by incremental aggregation?
Explain the difference between a data warehouse and a data mart?
Explain scd type 3 through mapping.
how we can load rejected record's at run time?(not through bad files)
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the limitations of joiner transformation?
can you please explain me pre session and post session options?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a passive transformation?
What is mapplet in informatica?
What is blocking transformation?