⟩ Why fact table is in normal form?
The fact table consists of the Index keys of the dimension/look up tables and the measures. So whenever we have the keys in a table. That it implies that the table is in the normal form.
Question and Answer:
Home Data Warehousing
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain What is ETL process ?How many steps ETL contains explain with example?
Explain What is Informatica Metadata and where is it stored?
How to call shell scripts from informatica?
Explain What is partitioning? What are the types of partitioning?
Explain Do we need an ETL tool? When do we go for the tools in the market?
How to use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain a mapping, session, worklet, workflow, mapplet?
Explain What is a staging area? Do we need it? What is the purpose of a staging area?
Explain What is Full load & Incremental or Refresh load?
Tell me can we override a native sql query within Informatica? Where do we do it? How do we do it?
