can u give example for factless fact table
- 2 Answers
- 5527 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 |
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
write a query to get maximum salary from the employers table without duplicates....kindly help me
What aer the out put files that the informatica server creates during the session running?
how will you get 21 to 30 record from 50 records?
what is procedure to use mapping variable in source qualifier transformation? with example
Which is the t/r that builts only single cache memory?
What is Collect performance data in informatica and what is the use of it.
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
What are the reusable transforamtions?
What are the session parameters?
How to delete duplicate record in Informatica?
Teradata 
