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 10614Post New VAMA Interview Questions
How does c# achieve polymorphism?
How can you work with permissions from your .net application? : java security
"In a four-stroke diesel engine, In what engine exhaust valve will open?"
What are the join problems comes appart from loop,chasm & fan Traps
How to defragment indexes with alter index ... Reorganize?
What is rural banking?
What causes hard disk failure?
How do I restore my start menu?
How do you resolve maven dependencies issue while upgrading dependencies versions?
What is a cross-reaction?
how many joints are allowed in underground HT cable of 1 KM
Is there a way to reference the "this" variable within a jsp page?
How do we delete the cache of the WebServer?
What is first in linq?
What is the use of transformation?