If the source has duplicate records as id and name columns,
values:
1 a, 1 b, 1 c,
2 a, 2 b,
the target should be loaded as 1 a+b+c or 1 a||b||c, what
transformations should be used for this?

Answers were Sorted based on User's Feedback



If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, t..

Answer / shankar

SQ--->SORTER---->EXP---->AGR---->TGT

1.First pass all records into sorter
seect sort key on id.
2. An pass records into EXP
In exp creat 4 pors like
v_id=id
v_name=nme
v_name1=iif(id=v_id,name||'+'||v_name,name)
o_name=v_name1
3.Next pass all to agr
ini agr creat one port like
o_name_t=last(o_nme).
4.Pass to Target

Is This Answer Correct ?    8 Yes 0 No

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, t..

Answer / babu

Sorry Shankar,

small mistake in your logic,

Exp Trans:
ID (I/O)
NAME (I)
V_NAME=IIF(ID=V_ID,V_NAME||'+'||NAME,NAME) (V)
V_ID=ID (V)
O_NAME=V_NAME (O)

=============
remaining is same.

Is This Answer Correct ?    2 Yes 0 No

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, t..

Answer / mithilesh kumar rai

First Use Expression and then Use Aggregater
After Expression U will receive
1 a
1 a b
1 a b c
2 a
2 a b
2 a b c

then use aggregater group by key 'ID'
After Aggregater u will receive
1 abc
2 abc

Is This Answer Correct ?    2 Yes 2 No

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, t..

Answer / souvik

We need to have a Lookup with a Dynamic Cache, a Router, an Expression and then an Update Strategy..... The Lookup will be on the Target Table..... So when the ID is coming for the first time, it wont found any data on the lookup table.... This can be directed for Insertion to the Target Table via a Router.... Then when the same ID is coming for the second time, it will Lookup on the Target Table and will found that the row with the ID exists.... Hence both the columns from the source table and both the columns from the Lookup are taken forward into the Router and then to an Expression Transformation where the second port is Concatenated. Then the ID port and this port is taken to the Update Strategy transformation for Update...

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Can we override a native sql query within informatica?

0 Answers  


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


To achieve the session partition what r the necessary tasks u have to do?

1 Answers  






what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,


how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,


What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,


Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  


connected and unconnected lookups?

4 Answers  


What is the functionality of update strategy?

2 Answers  


What is the function of aggregator transformation?

0 Answers  


Categories