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 10619Post New VAMA Interview Questions
How can we achieve thread safety in java?
What is ubuntu and how does it work?
how you establish the LOQ?
What is software process?
What is scenario manager?
In asset accounting what are the organizational assignments?
sir, I am from EEE branch.On feb 17 iam going to write an Exam for hindustan petrolium corporation Ltd.So plz send me the written exam pattern/Q's/interview questions.please mail to eee_dharmendra@yahoo.com
What does malloc () calloc () realloc () free () do?
What are the advantages of a Hybrid framework?
What happens if we don’t override a run method?
What task is 98% of the required work of a business analyst?
What are the authentication access types for a force.com canvas application?
What does set rowcount do?
1. Give me an example of something you tried at work but did not work out so you had to go at things another way. can somebody give a real time example
what type of quetion may be asked for experienced person in manual tester of 1 year?