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.
- 5 Answers
- 9141 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
What are the steps involved in the migration from older version to newer version of Informatica Server?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
can anyone explain me about retail domain project in informatica?
What is meant by active and passive transformation?
what is the -ve test case in your project.
How can you validate all mappings in the repository simultaneously?
What is the benefit of session partitioning?
Explain the code page compatibility?
What is meant by incremental aggregation?
What is the status code in stored procedure transformation?
What are the tasks that can be performed using sq?
How do you load alternate records into different tables through mapping flow?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is informatica worklet?
