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
- 9741 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
What is workflow manager?
Explain the different dimensions.
What is the procedure for creating independent data marts from informatica 7.1?
Explain about cumulative Sum or moving sum?
How do you load unique records into one target table and duplicate records into a different target table?
What is rank transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
hi real timers . iam waiting for ur reply regarding ETL TESTING
expain about the tune parameters?
What are the various types of transformation?
What will be the approach?
Explain sql transformation in script mode examples in informatica
How do you update the records with or without using update strategy?
Explain 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?
What is decode in static cache?
