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 10801Post New VAMA Interview Questions
hi i am electronics & telecomm engg & appling for apprentiship written test and interview. pls forward me the syllabus & old question papers.I will be very much thankful to you. pis inform to 88.avinashkalegmail.com
What is Java Swing?
What is spritekit and what is scenekit?
kindly sent some demo question and answer
What are considerations taken into account while creating a piston head?
What is the structure of bdcmsgcoll? : abap bdc
What is big data in dbms?
Explain the features of dojo toolkit ?
Which JavaScript objects are not accessible to web worker?
Which of the data type is compound datatype supported by PHP?
How to configure a read/write optical drive by using configuration manager?
How to run talend jobs in parallel?
What is a queue in mqseries?
Explain HDFS “Write once Read many” pattern?
What are Trigonometric Functions in AWK?