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 10653Post New VAMA Interview Questions
Why excel is important?
Cellulose is a polymer of repeating units of what molecule?
if the nitrates more than 45mg/l in water lead to disease then what is it called
What is clone tool?
how can you perform load testing in tableau?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
What is the advantage of scripted deployment in tibco?
What is a polyp? Can it develop in uterus?
How do you count loops in python?
we all know voltage is a force(emf), and the force always devides if 2 or more than2 loads are there but why does the voltage remains same is parallel, it must devide na ???
What are eigenvectors and eigenvalues?
What is articles?what are those and how its working in service contracts?
Name the building blocks of Angular?
what is the difference between pre-emphasis and modulation?
How to limit decimal places for the variable using proc means?