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
- 10633 Views
- Accenture, VAMA, I also Faced
- E-Mail Answers
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 Session and Batches?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Which development components of informatica have the highest usage?
draw informatica architecture 8.6 ?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a dimensional model?
What is an expression transformation in informatica?
How can a transformation be made reusable?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is the difference between router and filter?
Can we create two repositories on same database instance in oracle?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
