Answer / jyothiram

PUT SORTER WITH KEY OF ROWID IN FIRST EXPRESSION FLAG THE
RECORDS WHICH IS HAVING MORE THAN ONCE ,TAKE PRV PORT AS
VARIABLE MATCH IT WITH CURRENT AND SET FLAG OUT ACCORDINGLY,
IN NEXT EXPRESSION CHCEK FOR FLAG, IF IT SETS
DO 'XX'||SUBSTR(ROWID,3) OTHER WISE ROWID ONLY . HOPE THIS
WILL SOVE .

Answer / rajendra

Through Dynamic lookup you can handle it very easily.

Answer / krishnakanth.ch

First make sure the values are sorted by rowid and passed
to an expression transformaion.Now create a variable port
in the exp. Lets think var1 and make it empty in the
expression .

now compare rowid with var1 by

IIF(VAR1=ROWID,XX||SUBSTR(ROWID,3,3),ROWID)

When the session starts, since initially the var1 is null,
it will be replaced with first rowid. When the second
record is passed, the values will match the required format
of rowid will be passed and remember to pass the value in
the var1 to the next transformation or target.

Hope this will solve.
Please let me if anything is wrong or does not work out.

Answer / rao

its not working

Answer / mfg

create an output port and write the expression to replace
values or create a stored procedure and call it expression
transformation

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

What is a parameter When and where do you them when does the value will be created

0 Answers  

What is aggregator transformation in informatica?

0 Answers  

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

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   Wipro,

Define Incremental Aggregation?

2 Answers  

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

Does an informatica transformation support only aggregate expressions?

0 Answers  

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,