Answer / prabodh

S-->SQ-->SORTER-->EXP-->AGG-->TARGET
Sort on the firt port,in exp check prev and curr value by
using var ports,if same concat them ,u will get
101 a
101 a b
101 a b c
101 a b c d

from the Exp trans ,group by first port in the Agg trans ,u
will get last row i.e 101 a b c d.

Answer / arunakumaril

(here column names are not mentioned .so,i have taken them
as column1 and column2)

take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.

(variableports)curr_col1_val:column1

(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)

(variableports)pre_col1_val:column1

Answer / babu

Hi Aruna,

U r answer has small change,i.e one output port and in
aggregator t/r column1 is group by port not column2.

SRC
|
SQ
|
EXP
{
(variable port) var:IIF(col1=var1,concat(var,col2),col2)
(variable port) var1:(col1)
(output port) oup:var
}
|
AGGR(COL1 AS A GROUP BY PORT)
|
TRG

MAPPING DESIGN::

SRC-->SQ-->EXP-->AGGR-->TRG

Answer / arunakumari l

(here column names are not mentioned .so,i have taken them
as column1 and column2)

take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.

STEP1:
use this below logic in expression transformation:-

(variableports)curr_col1_val:column1

(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)

(variableports)pre_col1_val:column1

STEP2:
Take groupby on column2 in aggregator

Answer / santosh

HI ARUNAKUMARI,

IAM RAJU,WHAT IS MAPPPING DESIGN OF THIS SCENARIO AND WHERE WE DESIGN LIKE IN TRANSFORMER STAGE OR ANY AND WHAT IS(variableports)& WHICH STAGES ARE SQ AND EXP AND SORTER.
IAM A NEW IN DATASTAGE,PLS EXPLAIN ABOUT THIS CLEARLY

THANKS ADVANCE.
(here column names are not mentioned .so,i have taken them
as column1 and column2)

take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.

(variableports)curr_col1_val:column1

(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)

(variableports)pre_col1_val:column1

how to insert header after each group.

1 Answers   IBM,

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  

How to create the source and target database connections in server manager?

0 Answers   Informatica,

Two Default User groups created in the repository are ____ and ______

2 Answers  

Define maping and sessions?

3 Answers  

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

can we override a native sql query within informatica? Where do we do it?

0 Answers  

What are the types of error logs available in Informatica?

1 Answers  

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

2 Answers  

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

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

4 Answers   Cap Gemini, IBM,