Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10804 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
Can u generate reports in Informatica?
What is informatica powercenter repository?
How identifying bottlenecks in various components of informatica and resolving them?
Performance tuning( what you did in performance tuning)
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is a joiner transformation?
Define mapplet?
What is the meaning of decode in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Differences between connected and unconnected lookup?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Is it possible to define a single node as a Gateway node as well as worker node?
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.
Plz can any one say me how to get the informatica certification materials and dumps
