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 Answers
- 10806 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
what is $$$$?
What is lookup change?
Why union transformation is an active transformation?
How do you promote a non-reusable transformation to reusable transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What the difference is between a database, a data warehouse and a data mart?
Can we get 1st record through Informatica(without sequence number).
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the format of informatica objects in a repository?
Why do you use Mapping Parameter and mapping variable?
How identifying bottlenecks in various components of informatica and resolving them?
What you know about transaction control transformation?
Where are the source flat files kept before running the session?
Explain how to import oracle sequence into informatica?
