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
- 10433 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
design of staging area?
Enlist the tasks for which source qualifier transformation is used.
What are the informatica performance improvement tips
Explain sessions?
What is an expression transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How do you load only null records into target?
can we override a native sql query within informatica? Where do we do it?
What do you mean incremental aggregation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Differentiate between joiner and lookup transformation?
wf dont have integration severances how you can run?
Design a mapping to load a target table with the following values from the above source?
How can we update a record in the target table without using update strategy?
Explain the code page compatibility?
