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 9067Post New VAMA Interview Questions
Describe different transformations in dstream in apache spark streaming?
What are the types of testing can be performed on facebook login page?
Define what is point contact diode?
What is mysql workbench used for?
Is math class static in java?
Explain what are the different file extensions involved when programming in c?
What is NEFT / RTGS?
What is a package in java? List down various advantages of packages.
How do I use patreon rss feed?
How will you appraise your team's work?
How do I link access to excel?
1. a)in four digit no the fourth number is four time more than the second digit b)in four digit no the third number is three time less than the second number c)in four digit no the first digit is thrice than the fourth digit
What are the loan products of State bank of India?
What is mappedby attribute in hibernate?
What are the options to format a cell?