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 9148Post New VAMA Interview Questions
What does s mean in regex?
How connect plc and pc through software
What is space in html?
What salary range are you looking for at Edward Jones?
Describe about the libraries of python?
What is the indirect allocation method of postings in co? : co- cost center accounting
Why mobile phone has 10 digit numbers?
what is gr-edge edit?
What is asp.net caching?
what exactly u write in when_new_form_instance
Can datareader hold data from multiple tables?
What is IBM WebSphere?
As Derby is such a small DB, why do u prefer going for a Derby DB in a real-time project Implementation?
Is it possible to communicate to couchdb without going through http/ api?
How do I show all tabs in excel?