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
- 10617 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 informatica?
What are pre and post-session shell commands?
What are the components of Informatica? And what is the purpose of each?
What all join we can perform in LOOKUP transformation?
Explain the shared cache and re-cache?
What is different between the data warehouse and data mart?
what is the hint? how to use it to reduce the query processing in program?
What are roles and groups and benefits of using them?
What is a passive transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Separate from an archive server and a powerhouse?
Where do we use mapping variables in informatica?
Explain Dataware house architecture .how data flow from intial to end?
What does cheating measurement mean?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
