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.
Answer Posted / mukesh
Use an aggregator. 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,
Jan -> MAX(IIF(Month
= Jan,Sales)), Feb -> MAX(IIF(Month = Feb, Sales)), etc.
Without max, it will take last row..
Move these ports to the next transformation or to the
target. This should give the required output.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is intricate mapping?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is a filter transformation?
wat are deployement groups in informatica, how it will be used for developers
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to update a particular record in target with out running whole workflow?
what is informatica metadata?
How to join three sources using joiner? Explain though mapping flow.
explain about unit testing? in real time?
How do you manage the Parameter files while migrating your data from one environment to another environment?
explain one complex mapping with logic? sales project?
How can we use batches?
Enlist few areas or real-time situations where informatica is required.
What is xml source qualifier transformation in informatica?
What is aggregator transformation in informatica?