Interested to Buy Any Domain ? << Click Here >> for more details...
can u give example for factless fact table
- 2 Answers
- 6780 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 the Rank index port in Rank transformation?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
What are the guidelines to be followed while using union transformation?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Why we use partitioning the session in informatica?
During the running session, output files are created by informatica server. Enlist few of them.
What is the difference Between Mapping parameter and variable
What is a standalone command task?
What are the different lookup cache(s)?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
Which kind of index is preferred in DWH?
What are the mapping paramaters and mapping variables?
Teradata 
