What is factless fact schema?

Answer Posted / mln

The fact which does not contain any facts or mesaurables.
Ex:the fact table which is used to store the students
information is he came to school or not cannot have weather
they are attending all classes.
which is a measure

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Index Caches size?

722


Explain where to store informatica rejected data? How to extract the informatica rejected data?

693


Explian the Process of deployment groups in informatica

730


How to generate sequence numbers without using the sequence generator transformation?

750


Explain sessions. Explain how batches are used to combine executions?

694






What are the designer tools for creating transformations?

774


What is decode in static cache?

685


Differentiate between Load Manager and DTM?

1760


Where do we use mapping variables in informatica?

705


What does update strategy mean, and what are the different option of it?

696


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1979


In which transformation you cannot drag ports into it?

910


What is fact table? Explain the different kinds of facts.

692


How an expression transformation differs from aggregator transformation?

709


How to update a particular record in target with out running whole workflow?

1242