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.

Insert else update option in which situation we will use

4 Answers   HCL,

What is target update override

2 Answers   CTS,

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

Define Incremental Aggregation?

2 Answers  

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

What is the difference between a router and a filter transformation?

1 Answers   TCS,

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

what is a time dimension? give an example?

2 Answers   IBM,

How to extract the informatica rejected data?

0 Answers