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


Please Help Members By Posting Answers For Below Questions

Tell me about MD5 functions in informatica

497


How to configure mapping in informatica?

651


what is the complex transformation you used in informatica

2169


What are the main features of Oracle 8i with context to datawarehouse?

1662


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1557






What is xml source qualifier transformation in informatica?

687


which one is better performance wise joiner or look up

602


Have you worked with/created Parameter file

1199


Why update strategy and union transformations are active? Explain with examples.

682


How to update a particular record in target with out running whole workflow?

1131


What is complex mapping?

615


What are the types of schemas we have in data warehouse.

508


Explain what is informatica metadata and where is it stored?

592


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

605


Which files are created during the session rums by informatics server?

685