Answer / siva

Take the mapping as (suppose the columns as C1, c2)
SD --> SQ --> Exp --> Agg --> Tgt
In exp define as
c1 <-- c1
c2 <-- c2
v_2 <-- IIF(c1 = v_1,TO_CHAR(v_2) || ', ' || TO_CHAR
(c2),TO_CHAR(c2))
v_1 <-- c1
o_p1 <-- v_2
In Agg
Group by c1
c2 <-- v_2
c11 <-- LAST(c1)
Tgt is connected as
c1 <-- c11
c2 <-- c2

v_ stands for variable port and o_ stands for output port

I think it can be understood by you

Thanks for your response

Answer / siva

Use 2 variables one for counter and another for value.
sort all the records by c1 and keep track on c1 and hold
the value in v1. When the v1 and c1 are equal, then
concatenate c2 with v2 other assign c2 with v2. Finaly
connct to aggregator and take last value by grouping the
records by c1.


This will work..

Answer / shekhar

can u just explain in detail the concatenation part.

Answer / ganesh yadav

using Normalizer Transformation we can convert the multiple
columns as multiple rows, multiple rows as multiple columns...
rows: 1 1 1 2 2 2
a b c a b c
answer
column wise
1 a b c
2 a b c

Answer / swetha

Thru Normalizer t/r we can acheieve this.

What is target load order?

0 Answers  

How do you handle two sessions in Informatica

0 Answers   Informatica,

What are the tasks that Loadmanger process will do?

1 Answers  

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

what is difference between dimention table and fact table?

1 Answers  

performance wise which one is better in joiner and lookup transformation

2 Answers  

Separate from a database, an information bazaar, and an information stockroom?

0 Answers  

How to elaborate powercenter integration service?

0 Answers