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
- 10423 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
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Under which circumstances, informatica server creates reject files?
What is Index Caches size?
What the difference is between a database, a data warehouse and a data mart?
What is a filter transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the maplet?
permutations of mapplet
What is a sequence generator transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What does cheating measurement mean?
What are the main features of Oracle 8i with context to datawarehouse?
Can you use flat files in Mapplets.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What all join we can perform in LOOKUP transformation?
