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.
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
Differentiate between reusable transformation and mapplet.
what is the hint? how to use it to reduce the query processing in program?
What is a connected transformation?
What is DR strategy for Informatica project?
Explain the shared cache and re-cache?
Explain the different lookup methods used in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
While migrating the data from one environment to another environment how would you manage the connections?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the types of presistent cache in look up tr.
Where are the source flat files kept before running the session?
How to do unit testing in informatica? How to load data in informatica ?
How do you use reject loader.
To import the flat file definition into the designer where should the flat file be placed?