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 10626Post New VAMA Informatica Interview Questions
what is an alias command? : Sql dba
Which element in 1A group is lighter than water?
Explain features and concepts of analysis services?
Hi to all, im vaibhav i joined a MNC as a tester and i got a banking (HSBC) project can any one tell me as a fresher what kind of strategy i sholud use to perform better. thanx
What is fetchtype lazy?
How to set an Enhancement point for a custom report?
What are access specifiers in java ?
what is document design in boxi,have u participate in that
Why do you want LIC?
Explain about core dimension, balanced dimension, and dirty dimension?
What is ms word introduction?
What does the ADSL WIC enable?
Why is vlookup showing na?
How will you explain machine learning to a layperson?
How to call a sub procedure?