What is facttable granularity?

Answer Posted / sri ram

The level of details to be stored in fact table is termed
as granularity.
Eg: for a Retail store, the granularity for sales fact is
as that of Point Of Sales i.e., each transaction occurs,
the data is stored in the fact table.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create two repositories on same database instance in oracle?

604


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

548


How would you copy the content of one repository to another repository?

549


In warehouses how many schemas are there?

577


What is informatica?

675






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

584


How can we use mapping variables in informatica? Where do we use them?

616


What is InformaticaPowerCenter?

679


Performance tuning( what you did in performance tuning)

1483


Write the different tools in the workflow manager?

569


draw informatica architecture 8.6 ?

3468


What is the difference between stop and abort in informatica

655


What is sorter transformation?

576


What is target designer and target load order?

652


What do mean by local and global repository?

697