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.
Answer Posted / pallavi
we could do it using Normalizer.
Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
What's the layout of parameter file (what does a parameter file contain?)?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Define update strategy?
Explain the tuning lookup transformation - informatica
Define joiner transformation?
How to load the data from people soft hrm to people soft erm using informatica?
What is Index Caches size?
What is aggregate cache in aggregator transformation?
How to use pmcmd utility command?
What is target designer and target load order?
What are the conditions needed to improve the performance of informatica aggregator transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what is diff b/t sorter t/r and agg have the option sorter property...
Explain about cumulative Sum or moving sum?