1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / babu

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


Please Help Members By Posting Answers For Below Questions

What are the measure objects?

677

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1643

How can we improve session performance in aggregator transformation?

682

define galaxy repository in informatica

1736

How many types of sessions are there in informatica.please explain them?

685




Enlist the various types of transformations.

566

what is diff b/t sorter t/r and agg have the option sorter property...

1756

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

3463

What is complex mapping?

652

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

820

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

668

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

639

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5590

How do you set a varible in incremental aggregation

1457

waht type of interface is used for testing the data in informatica

1846