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 Interview Questions
In pickling process of titatium with HCL . how to know if the acid is not effective after pickling several batch. is there any test to know it. (not practically)
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
Are cookies stored on server or client?
How do I remove white space in word 2016?
How to add wpf user control in windows form?
What are the site types supported by homestead?
Can we provide one default constructor for our class?
What are wcf service endpoints? Explain.
How much space does sql server 2016 take?
Is activex secure?
I have certain queries, please help to solve. a) length of pile bore is 4m.excavation quantity will be area * length where area will be pi/4 * dia*dia. Is this right? b) It is a single reamed pile of 300m dia and reamed dia is 750mm. can any body help me to calculate excavated quantity of this bulb(reamed section),, concrete quantity in bulb with showing the formulas to be used?
When a sales order contains normal(norm) and third party items(bans) how does the material reacts? Next order comes as make to order(0001), another is BOM. So every time we have to change the item category group in mm02 OR is there a process to expand the same material with norm, bans, 0001, erla?
How do I stop a python script?
What is deep linking in angular js?
What is aop module?