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.

How to use pmcmd utility command?

0 Answers  

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

What are ETL Tools?

0 Answers   Informatica,

why we are using surogate key in real time give me explanation

2 Answers   TCS,

What is partioning?how many types of partinings are there

2 Answers   HCL,

what is upstream and downstream transformation?

7 Answers  

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

What are the basic needs to join two sources in a source qualifier?

4 Answers  

what is filelist concept in informatica

4 Answers