can u give example for factless fact table
- 2 Answers
- 5522 Views
- TCS, I also Faced
- E-Mail Answers
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 |
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
If we are using an aggregator but forget to mention the group by port .what will be the output??
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Which is better performance wise database or file?How?
Kimball and Inmon methodologies?
why we use informatica in our project?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
How many mapplets u have created? and what is the logic used
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
Teradata 
