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
- 10613 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 is the sequence generator transformation in informatica?
Describe expression transformation?
How many transformations can be used in mapplets.
what is INFORMATICA TESTING process
What is decode in informatica?
Implementation methodology
explain abt ur project architecture?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain the difference between mapping parameter and mapping variable?
What is workflow manager?
What are the performance considerations when working with aggregator transformation?
Does an informatica transformation support only aggregate expressions?
tell me 5 session failure in real time how can you solve that in your project?
explain one complex mapping with logic? sales project?
What is the benefit of session partitioning?
