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 10431Post New VAMA Interview Questions
How do you restrict the data to be entered in the payroll area?
What is the capital adequacy ratio?
Explain what you understand by speculative execution
Explain what is perl language?
Are there any methods of preventing cracking of carbon steel welds in refining environments?
How do I use solver constraints in excel?
How do you convert a string to in python?
What is a j2ee container?
How to write test case for this scenario. If the Zip Code field is populated, the system shall compare the zip code value entered to the zip code value in the Family Individual Information Tab
If a nri buys property in india, does he has to pay property tax?
Explain about objects in Microsoft Windows 2000?
Why is my rss feed not working?
What is the executescalar method?
whether allowances will be included in calculating esi from gross salary
Can I Obtain Bankruptcy Protection Again If I Have Filed A Bankruptcy In The Past And Am Now Falling Behind In Payments Again?