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 10643Post New VAMA Interview Questions
If Web site developer want to evaluate their current authoring tool, where would they start?
When I click on an excel file to open it, the file opens but an error message is displayed that says a file with that name is already open and that I can not open twofiles open with the same name?
Which are the Layers that the scope of Cloud Computing?
What is application client module?
What are the benefits of oracle rac?
How do I fix windows 10 registry file is missing or corrupt?
What is the difference between lookup (), lookup_ext () and lookup_seq ()?
Define circuit turn off time
How many types of protection relays are there based on the characteristic?
How will your education help us in improving the banking services?
How will you create a pills navigation menu?
Does c# support templates?
What are the enhancements one can do in SAP MM,PP,SD, modules while extracting the data?
Give a brief introduction to data mining process?
Differentiate between vector and array list.