Interested to Buy Any Domain ? << Click Here >> for more details...
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 aggregate cache in aggregator transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Explain your project of banking domian.
Which are the different editions of informatica powercenter that are available?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Slowly changing dimensions, types and where will you use them
What are the differences between source qualifier and joiner transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the main issues while working with flat files as source and as targets ?
What happens when a session fails and you click on recover?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Under which circumstances, informatica server creates reject files?
How many ways are there to create ports?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain lookup transformation in informatica
