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
- 10645 Views
- Accenture, VAMA, I also Faced
- E-Mail Answers
Answer Posted / janet
Simple SQL logic in the source qualifier sql will take care
of this issue.
Select product_id, month, sum(sales)
from source_table
group by product_id, month;
Then you can just pass the values straight through. No
need to split, aggregate, and join, etc.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What is the advantage of informatica?
What is the difference between informatica 7.0 and 8.0?
What are the databases that informatica can connect to windows?
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.
Differentiate between sessions and batches?
Explain transaction control transformation in informatica
What are the modules in Power Center
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How would you copy the content of one repository to another repository?
What are pre and post-session shell commands?
What is a filter transformation?
list out all the transformations which use cache?
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?
Can we create multiple integration service on single repository?
What is aggregator transformation in informatica?
