Interested to Buy Any Domain ? << Click Here >> for more details...
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 10431Post New VAMA Informatica Interview Questions
-
VAMA Informatica Interview Questions (1)
Write a program to explain the comparator?
What is h:form tag in jsf (javaserver faces)?
What are the different data types that a standard field record name can have? : salesforce crm
Can you call from an inherited constructor to a specific base constructor if both base class and an inheriting class has a number of overloaded constructors?
How to add Hibernate mapping file in hibernate configuration file?
What additional date fields can you add using a Master Calendar?
Given two strings, find the sub-string of the first string having minimum length which is having all the characters in second string
What is itemgetter in python?
Difference between static and dynamic class loading.
What is factor r?
How do you maintain exchange rates in sap? : cost center accounting
How to generate Random numbers without using Rnd() ?
Explain the role of repl in node.js?
What are telerik controls?
which programming language did you use to make your project?
