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 data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

what are the types of Data warehousing ?

1 Answers  

What is query panel?

1 Answers  

Mapplets can you use an active transformation in a mapplet,

1 Answers  

what is SDLC way of code development?

0 Answers  

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 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,

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers