⟩ What are the methodologies of Data Warehousing?
Every company has methodology of their own. However, to name a few SDLC Methodology, AIM methodology is standard used.
Every company has methodology of their own. However, to name a few SDLC Methodology, AIM methodology is standard used.
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?
Explain Is there any way to read the MS Excel Datas directly into Informatica?Like IS there any Possibilities to take excel file as target?
Explain What are the various methods of getting incremental records or delta records from the source systems?