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
- 9097 Views
- Accenture, VAMA, I also Faced
- E-Mail Answers
Answer Posted / pallavi
we could do it using Normalizer.
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
What are the different types of olap? Give an example?
What is informatica metadata and where is it stored?
What is rank transform?
Is it possible to define a single node as a Gateway node as well as worker node?
What is mapplet in informatica?
How do you handle two sessions in Informatica
What is meant by pre and post session shell command?
What are the components of the workflow manager?
What is enterprise data warehousing?
Can we override a native sql query within informatica?
What is data transformation manager process?
what is unit testing?tell me proceedure
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 Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain the features of connected and unconnected lookup.
