Basic difference is E-R modeling will have logical and physical model. Dimensional model will have only physical model. E-R modeling is used for normalizing the OLTP database design.Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.
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?
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?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
