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. what is the procedure and whar t/r's are involved
and what is the mapping flow
- 4 Answers
- 12192 Views
- Wipro, I also Faced
- E-Mail Answers
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
Explain the use of aggregator cache file?
Which files are created during the session rums by informatics server?
What are the reusable transformations?
State the differences between sql override and lookup override?
pmscmd startworkflow -sv
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are roles and groups and benefits of using them?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a joiner transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Difference between Target-based loading and constraint-based loading?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain joiner transformation in informatica
How do you load unique records into one target table and duplicate records into a different target table?
wf dont have integration severances how you can run?
