Answer Posted / ankit kansal
Take two dimensions as dim_time and dim_product and
a fact table as fact_sales
Now provide a reference from both of the dim tables to the fact table and while loading from the source do not load any other data.
Now you can easily report out
product sold per day
product sold per month
product sold per year
e.t.c.
deepinopensource.blogspot.in
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is substr in informatica?
What is an expression transformation in informatica?
What is InformaticaPowerCenter?
What is rank transform?
Briefly describe lookup transformation?
What you know about transaction control transformation?
What is Data Caches size?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How do you load only null records into target?
What are the differences between joiner transformation and source qualifier transformation?
Design time, run time. If you don't create parameter what will happen
what is mean by complex business rule ?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the different types of repositories created using informatica?
draw informatica architecture 8.6 ?