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 10488Post New VAMA Interview Questions
What are scriptlets in jsp?
Can we override constructor in c#?
Explain Fundamental Analysis.
Why do we use drupal?
what is trainer's defination and quality?
What is the best backend language?
Explain favicon in drupal?
What is inode in unix operating system?
Are views faster than queries?
Who is the regulator of SEBI?
What is purpose of the data item?
What does the command ' $who | sort –logfile > newfile' do?
any one can provide me some sample resume for SAP PP with 0 to 1 year experience?
What is ado in vb.net?
Explain Features of WordPress?