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 10802Post New VAMA Interview Questions
What are the main things need to consider in the “master-detail relationship”?
Which method is primarily used for Voice transfer?
What is a column break?
How to add an address record into adventureworkslt?
while am calibrating Drager polytron 2IR flame gas detector occured non zero status.how can i get zero status?
Explain a linked cube?
Is it possible to display props on a parent component?
List out benefits of object oriented programming language?
Is hcl polar or non-polar?
Is advanced java and j2ee same?
What does i ++ mean in Java?
SOQL & SOSL? Diff between SOQL & SOSL?
Rules for filling Income Tax return for a MNC?
What is laravel horizon?
Tell me can you extend a final defined class?