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 10443Post New VAMA Interview Questions
What is the forbidden energy gap? How does it occur?
Is it possible to provide method implementations in java interfaces? If possible, how do we provide them?
How do you process errors in call transaction method? : abap bdc
What is the difference between lambdas and delegates?
How do I get apache spark on windows 10?
How to set the timeout property for the wcf service client call?
For sales document: item data, which table is used?
How do you check if windows 10 is corrupted?
Will my apps still be there after I upgrade?
What is oo integration testing?
What is timestamp in mysql?
What is difference between html and http?
What is the use of awk command in unix?
we are about to implement a Test tool to test the performance of website, so what script does a tester should know (friends plz help me)
Define the types of selectors in jquery?