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 10446Post New VAMA Informatica Interview Questions
What is the default wordpress theme?
According to you what goes into making the best database administrator? : sql server database administration
Define psb?
What are the 5 layers of tcp ip?
What is data structure explain in detail?
How to record & run on japanese language application using english version of ibm?
How can we read file using curser? how to define a curser?
what post steps and pre steps db refresh
minimum percentage in B.E in(INFORMATION TECHNOLOGY) to be eligible for IES exam qualification and also for reserved categories.are IT engineers are eligible for giving IES exams? please reply soon.
1· What is a bad credit score? 2· What does my credit score mean? 3· Can I check my Vantage credit score range online? 4· Should I have perfect credit score, that is, above 800 credit score? 5· With a 600 credit score, how to improve my credit rating score? 6· How to raise my credit score if I have 500 credit score? 7· How to increase your credit rating score quickly? 8· How can I find out my credit rating score for free? 9· Home Equity Loans ????????· 10. Calculate Mortgage 11· Mortgage Payment 12· Mortgage Payment Problems
What is the purpose of button groups?
How can I calculate per unit (KWH) fuel (Gas/ Diesel both) consumption 1MW unit?
Why do we need master page in asp.net?
What is loop1 and loop2 in MTS LT?
Mention what are the types of semi-conductors?