Use an aggregator tx. Pass the ports (Product

Suppose we have a (assume relational) source table

Product_Id Month Sales
1 Jan x
1 Feb x
. . .
. . .
1 Dec x
2 Jan x
2 Feb x
. . .
. . .
2 Dec x
3 Jan x
3 Feb x
. . .
. . .
3 Dec x
. . .
. . .

and so on. Assume that there could be any number
of product keys and for each product key the sales
figures (denoted by 'x' are stored for each of the
12 months from Jan to Dec). So we want the result
in the target table in the following form.

Product_id Jan Feb March.. Dec
1 x x x x
2 x x x x
3 x x x x
.
.

So how will you design the ETL mapping for this case ,
explain in temrs of transformations.

Question Posted / girish

5 Answers
10497 Views
Accenture, VAMA, I also Faced
E-Mail Answers

Answer Posted / girish

Use an aggregator tx. Pass the ports (Product_id, Month,
Sales) to aggregator, group by Product_ID, manually create
12 ports for month like Jan, Feb, Mar, etc. Include an
expression for 12 ports, individually, as Jan -> IIF(Month
= Jan,Sales), Feb -> IIF(Month = Feb, Sales), etc.

Move these ports to the next transformation or to the
target. This should give the required output.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the advantages of informatica?

973

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2041

Separate from a database, an information bazaar, and an information stockroom?

1043

list out all the transformations which use cache?

1145

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2269

How to load the data from a flat file into the target where the source flat file name changes daily?

1027

without table how to come first record only in oracle?

2221

What are the prerequisite tasks to achieve the session partition?

1207

What the difference is between a database, a data warehouse and a data mart?

1111

Explain constraint based loading in informatica

1061

What is decode in static cache?

1117

Explain incremental aggregation in informatica

1093

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2108

Differentiate between a database and data warehouse?

1108

How can repository reports be accessed without sql or other transformations?

1184