Explain factlessfact table with scenario

Answer Posted / tamilarasan

Factless fact table - it doesn't have any measures
There are types in this
Additive : we can calculate all the aggregate function in this
Semi: we can do only particular calculation
Non : no calculation can be done

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you differentiate between powercenter and power map?

729


What are different types of transformations available in informatica?

670


is it possible to index the data in cache of lkp transformation ?

1625


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1555


What is Index Caches size?

722






Define enterprise data warehousing?

742


Tell me about Propagate functions in informatica

621


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1845


Explain lookup transformation source types in informatica

785


How do you load unique records into one target table and duplicate records into a different target table?

828


What are the components of the workflow manager?

749


Is it possible to revert a global repository to local one and why?

717


What is difference between a gateway node and worker node?

734


How do you migrate data from one environment to another?

729


What is the difference between STOP and ABORT options in Workflow Monitor?

802