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 difference between "echo" and "print" in php?
sir pls send the je exam - 2008 and other model question papers..
What are the analyses provided by the study of human age pyramids?
An application package has been provided to you without any documents for the following application. The application needs to be tested. How will you proceed?
What is the mechanism of host defense in trypanosomiasis?
What are the record types?
What are group functions in query statements in ms sql server?
What is Defragment?
HOW CAN WE GET THE AGREEMENT OR CONTRACT AS A CARRY AND FORWARD AGENT IN A COMPANY?
How to install unix on windows 10?
What is framelayout ?
Can you anybody give the FICO Tickets like Low,Medium,High & Critical issues with some examples in the real time happened. please forward it to my mail id...mamidi1980@gmail.com
What is a hidden script in qlikview?
Is java or python more useful?
What is the use of @autowired annotation in spring?