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
- 12322 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
Enlist the various types of transformations.
How to update a particular record in target with out running whole workflow?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
how to load dimension table and fact table. plz tell me the steps.
What is a connected transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Why do we need informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Differentiate between joiner and lookup transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How do you load unique records into one target table and duplicate records into a different target table?
Explain what is informatica metadata and where is it stored?
Explain sql transformation in script mode examples in informatica
How to generate sequence numbers using expression transformation?
