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 the flat file partition and where have to specify it

1 Answers   TCS,

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

How informatica process data means how informatica works?

2 Answers   TCS,

What are the joiner caches?

3 Answers   Informatica,

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

How can you complete unrcoverable sessions?

1 Answers  

In informatics server which files are created during the session rums?

0 Answers