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 Answers
- 9743 Views
- Accenture, VAMA, I also Faced
- E-Mail Answers
Answer Posted / seekax
The reverse operation can be done using normalizer . . . To
carry out this process above mentioned we need to use
spliter in combination with joiner . . .
---- split using month -------- (into 12 sets of 2-columns)
1st SET 2nd SET
------- --------- . . . . .
product id,jan product id,jan
1,x 1,x
2,x 2,x
3,x 3,x
4,x 4,x . . . . . . .
---- join using product_id --------
Product_id Jan Feb March.. Dec
1 x x x x
2 x x x x
3 x x x x
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
how to create user defined function (udf) in informatica
How to create or import flat file definition in to the warehouse designer?
Is it possible to use a client with different version than that of its Informatica server?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Design a mapping to load the cumulative sum of salaries of employees into target table?
What do you understand by SOA of Informatica?
How union transformation is used?
Briefly explain the aggregator transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what is Active lock explain
can we override a native sql query within informatica? How do we do it?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the need for an etl tool?
What will be the approach?
