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
- 10807 Views
- Accenture, VAMA, I also Faced
- E-Mail Answers
Answer Posted / janet
Simple SQL logic in the source qualifier sql will take care
of this issue.
Select product_id, month, sum(sales)
from source_table
group by product_id, month;
Then you can just pass the values straight through. No
need to split, aggregate, and join, etc.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Is there any way to read the ms excel datas directly into informatica?
what is the size of u r source(like file or table)?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How to update a particular record in target with out running whole workflow?
What is depict expression change?
How can repository reports be accessed without sql or other transformations?
What is rank index in rank transformation?
What's the layout of parameter file (what does a parameter file contain?)?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain why we use partitioning the session in informatica?
explan ur project architecture?
What is an aggregator transformation?
Explain constraint based loading in informatica
How do you promote a non-reusable transformation to reusable transformation?
