Does Facttable Normalized or Denormalized?

Answer Posted / chandrasekar

Fact tables are normalized. Dimension tables are denormalized

Is This Answer Correct ?    27 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can anyone explain me about retail domain project in informatica?

7416


Can anyone tell me the new features in Informatica 9 Version?

1522


explain one complex mapping with logic? sales project?

6134


update strategy transformation in informatica

629


What does refresh system mean, and what are its distinctive choice?

562






What are the different components of powercenter?

572


What is different between the data warehouse and data mart?

621


Mention a few design and development best practices for informatica?

549


What is InformaticaPowerCenter?

679


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

593


What are the popular informatica products?

642


What is an active transformation?

639


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1726


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

604


What are the features of complex mapping?

634