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 9095Post New VAMA Interview Questions
What is Xeon Processor Technology?
What is a p-n junction diode? State and explain some of its applications.
How an rtd work, and what volts/current goes to a rtd to measure the resistance?
Where is copy exe located in windows?
What is the maximum size of a database that can be opened in Microsoft Access?
How many ways a relational source definition can be updated and what are they?
Tell me how you define instance variable, global variable and class variable in ruby?
What is a storage key?
What is iis used for?
What happens if the execution of a smart contract costs more than the specified gas?
i am astubent of BE3rd year currently in 6th semester branch information technology till now i have 73% near about in each semester the problem with me is that i have got only 58%in 12th class n 55%in 10th class bcoz of my health now i am ok i have got 2 year loss also bcoz i have not giveen the exam in class 12th rite now i am prep for GATE i am working hard pls tell will i get a good job in future in the good company bcoz my inter percent were not gud pls tell me help me pls
What are the Packages of websphere?
explain about sla?
Explain about SAP IBP module?
How does 'automatic account assignment' work in mm?