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 10618Post New VAMA Interview Questions
What are the three tactical elements of electronic warfare?
Is mvc a framework?
What is the difference between char array and char pointer?
Is ms access easy to learn?
How to write a query with an inner join in ms sql server?
Where sessions are stored?
Explain a system in safe state?
What are features of react.js?
Is there any limitation for using WordPress?
Explain briefly the string addressing mode with the help of an example?
Explain the different groups under web logic security?
What is the difference between uniformity of content and content uniformity as official test for all tablets?
what is a static variable...wht is the size when u give sizeof(struct)
What is REST and what is the problem with WCF REST and how it can be resolved?
What is the difference between flush and commit in hibernate?