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 9107Post New VAMA Interview Questions
how many types of spped sensors n vibration sensors?their basic principle n connection?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Explain different types of lock modes in sql server 2000?
Why are spreadsheets so important?
What are spring components?
any C program contains only one function, it must be a) void () b) main () c) message () d) abc ()
Why string objects are immutable in java?
What is the difference between BPEngine and Integration engine?
What are the steps to be followed to set lockobjects? : sap abap data dictionary
operation of protection relay watchdog contact?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?
What is the use of the shipping process in sap sales and distribution? How do you define modes of transport?
What are the different types of APIs available in Node.js?
what is profit and loss(dr) in cash flow statement?
Is angularjs mvvm or mvc 4?