⟩ What is conformed fact?
Conformed dimensions are the dimensions, which can be used across multiple Data Marts in combination with multiple facts tables accordingly
Conformed dimensions are the dimensions, which can be used across multiple Data Marts in combination with multiple facts tables accordingly
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?
Explain What are snapshots? What are materialized views & where do we use them? What is a materialized view log?