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
- 10805 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
Define Pmrep command?
What can we do to improve the performance of informatica aggregator transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Define the various join types of joiner transformation?
Enlist the advantages of informatica.
How to extract the informatica rejected data?
Explain the shared cache and re-cache?
In development project what is the process to follow for an etl developer from day1
What is olap (on-line analytical processing?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the main features of Oracle 8i with context to datawarehouse?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Which version configuration tool used in ur project?
What does command task mean?
