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
- 9709 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
difference between informatica 8.1.1 and 8.6
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
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?
waht type of interface is used for testing the data in informatica
What is a stored procedure transformation?
How do we call shell scripts from informatica?
Briefly define a session task?
What is the fact table?
Explain constraint based loading in informatica
In how many ways we can create ports?
What are the data movement modes in informatica?
How to elaborate tracing level?
Explain the scenario which compels informatica server to reject files?
Explain scd type 3 through mapping.
How union transformation is used?
