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

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

What is source qualifier?

6 Answers   SDS,

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  

How the Informatica Server reads perameter file?

1 Answers  

Can a joiner be used in a mapplet.

1 Answers  

what type of transformation is not supported by mapplets?

4 Answers   CTS,

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,