Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details
- 8 Answers
- 18180 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi All,
SRC==>SQ==>EXP1==>SRTR==>EXP2==>RTR==>TG1
|| || ||
SEQ1 SEQ2 ==> TG2
EXPEL NATION OF MAPPING
=======================
1.EXP1: ADD ONE OUTPUT PORT AND ASSIGN THE NEXT VAL PORT FROM SEQ1 TO OUTPUT PORT.
i.e: O_SEQ1=SEQ.NEXTVAL
2.SRTR:SORT THE COLUMNS BASED ON THE O_SEQ1 IN DESCENDING ORDER.
3.EXP2:ADD ONE OUTPUT PORT AND ASSIGN THE "NEXT VAL PORT" FROM SEQ2 TO THIS OUTPUT PORT.
i.e:O_SEQ2=SEQ2.NEXTVAL
4.RTR: GRP1(O_SEQ1>=O_SEQ2)
GRP2(O_SEQ1<=O_SEQ2)(DEFAULT GROUP)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is sequence generator transformation in informatica?
which one is better performance wise joiner or look up
if we have a delimiters at unwanted places in a flat file how can we over come those.
what are 3 tech challenges/ common issues you face?
What differs when we choose the sorted input for aggregator transformation?
What is the way to execute pl/sql script using informatica mapping?
What is a snowflake schema?
what is size of u r database?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you set a varible in incremental aggregation
What do you understand by SOA of Informatica?
Write the advantages of partitioning a session?
How to join three sources using joiner?
What is target designer and target load order?
What is the function of union transformation?
