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
- 10643 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
Design time, run time. If you don't create parameter what will happen
can u any challenge your project?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
can anyone explain me about retail domain project in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What do you understand by a term domain?
What is event and what are the tasks related to it?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How to differentiate between the active and passive transformations?
How you prepared reports for OLAP?
Make a note of the quantity vaults made in informatica?
What is dimensional table? Explain the different dimensions.
