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 10632Post New VAMA Informatica Interview Questions
-
VAMA Informatica Interview Questions (1)
How do you generate a random number in c++?
what is the formula/ ratio for hollow block? considering to a 40 kgs of portland cement.
what is the major ticket in your experience
What is the use of iron core in a transformer?
What is an optimization and performance tuning and how does it really work in practical projects?
What is the use of defining workflow scenarios in workflow engine?
what is offset? Without offset we create queries?
How would you involve in yourself in a book club?
Differentiate between an external iterator and an internal iterator? What is the advantage of an external iterator.
Can reconstituted SMP be autoclaved?
What is the full form of exe?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How do I run windows 7 as an administrator?
explain about data integrator metadata reports? : Sas-di
Write a C program for level order traversal of a tree?
