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
- 10798 Views
- Accenture, VAMA, I also Faced
- E-Mail Answers
Answer Posted / pallavi
we could do it using Normalizer.
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
How to call shell scripts from informatica?
How to update source definition?
how tokens will generate?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is a grid in Informatica?
What is blocking transformation?
Name the different lookup cache(s)?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
difference between repository database and repository service?
Explain in detail scd type 2 through mapping.
What is joiner transformation in informatica?
Explain the difference between mapping parameter and mapping variable?
what are factless facts? And in which scenario will you use such kinds of fact tables.
