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 / 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
pmscmd startworkflow -sv
What are the settings that you use to configure the joiner transformation?
What is the difference between a repository server and a powerhouse?
What is a difference between complete, stop and abort?
What is sq transformation?
What is standalone command task?
How can you differentiate between powercenter and power map?
How big was your fact table
Explain joiner transformation in informatica
What are pre and post-session shell commands?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is xml source qualifier transformation in informatica?
How do you use reject loader.
Explain the different kinds of facts.
Explain the features of connected and unconnected lookup.