can u give example for factless fact table
Answers were Sorted based on User's Feedback
Answer / srinivasulu raju
Factless fact table is used to track the Events.
Eg: Attendance System.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
What are Rapid changing dimensions?
without table how to come first record only in oracle?
How would you join a node to the already existing domain?
what are the limitations of pushdown optimization technique ? Advance thanks
What is difference between maplet and reusable transformation?
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
Is there any target staging area in informatica not staging area
What is parameter file?
waht is dataware house
what is pre and post sql and what is diff between source presql and target pre sql
what is flat file override?