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 10513Post New VAMA Interview Questions
What is Your Cluster size ?
What is a final variable?
What is value type and refernce type in .net?
What is a placeholder on word?
Can we configure two instances of CMS pointing to two different CMS system databases?
What is type conversion in java?
What is use of odata protocol?
What is spark certification?
What is Apex Email Service?
How to create and use custom pipes? How to create a globally available custom pipe?
Can viewdidload be called multiple times?
How many rows and columns in ms excel 2007?
What are three ways in which a thread can enter the waiting state?
How is hashmap o 1?
How can you retrieve a particular number of records from a table?