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 9552Post New VAMA Interview Questions
How do I append in excel?
What are the attributes of applet tag?
What is writeline?
The function of Differential is a) To prevent wheel skidding b) To reduce the speed of the inner wheels during turning c) To keep the speed of all the wheels same when going straight ahead d) all of the above
What is a SharePoint Feature? What files are used to define a feature?
Can one function call another?
What is com binder?
Explain the importance of implementing a fault tolerance system? Are there limitations?
What do you mean by automated testing?
How to use filtering function in xslt? : xslt
What is volatile data type?
Can you create a data storage area in the sap bw?
Find the area of the disc at 62 c whose diameter is 3.4m at zero degrees celsius. Linear coefficient of expansion is .0000118 per degree c.
Which keyword is used for inheritance in typescript?
What is the term for the ph at which an amino acid or protein becomes electrically neutral?