can u give example for factless fact table
- 2 Answers
- 5500 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 |
what is metadata?
what is the diff b/w cached and unchaed look ups
can you avoid static cache in the lookup transformation? I mean can you
In dimension and fact table? which one holds big data?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
tell me 5 session failure in real time how can you solve that in your project?
What is confirmed dimension?
difference between repository database and repository service?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
Teradata 
