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
Tell me about MD5 functions in informatica
How to configure mapping in informatica?
what is the complex transformation you used in informatica
What are the main features of Oracle 8i with context to datawarehouse?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is xml source qualifier transformation in informatica?
which one is better performance wise joiner or look up
Have you worked with/created Parameter file
Why update strategy and union transformations are active? Explain with examples.
How to update a particular record in target with out running whole workflow?
What is complex mapping?
What are the types of schemas we have in data warehouse.
Explain what is informatica metadata and where is it stored?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Which files are created during the session rums by informatics server?