Answer / nitin

Create two mapping pipelines
One pipeline is to
1) Break the record 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B using normalizer transformation
1|A
1|B
1|C
1|D
2|A
2|B
3|A
3|B
Then pass the records into a flat file target.

Source-->SQ-->Normaliser--> Target (Output_file1)
Output_file1-->SQ--> Aggregator-->Target(Output_file2)


Create another mapping pipeline where the above records act as the source and the delimiter as '|'.
Use an aggregator transformation to group based on the first column and use the SUM(col2) GROUP BY col1.
write the output to the target file with | as delimiter

Answer / nitin

1) Src-->SQ->Normalizer-->Target
The first pipeline breaks the rows and convert to columns and then write to target file.
1|A
1|B
1|C
1|D
2|A
2|B
3|A
3|B

2)Src->SQ->Exp->Target
The second pipeline receives the above output with '|' as delimiter and passes to expression.
In the expression transformation concatenate the second column with + for the same first column and then write to target with | as delimiter

Answer / ankit kansal

There is only one row as per the defined problem. so first you have to break down this one row into multiple rows as separated by delimiter ','.
1|A
1|B
1|C
1|D
2|A...
Now in Expression Transformation using some string functions and later using rank/aggregator T/S you can achieve your result...

http://deepinopensource.blogspot.in

Answer / amedela chandra sekhar

By using aggregator t/r we can achieve.
use || function

Answer / guest

Aggregator with group by on column with values 1, 2, 3

What is facttable granularity?

2 Answers  

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

Mention few advantages of router transformation over filter transformation.

0 Answers  

How you count the number of records available at your source?

3 Answers   Zensar,

what we require for D.modelling?

1 Answers  

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

What are the various types of transformation?

0 Answers  

Is informatica power center designer has 64 bit support?

1 Answers  

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers