View - store the SQL statement in the database and let you use it as a table. Every time you access the view, the SQL statement executes. Materialized view - stores the results of the SQL in table form in the database. SQL statement only executes once and after that every time you run the query, the stored result set is used. Pros include quick query results.
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?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA?
Explain the different Lookup methods used in Informatica?
Explain When do we Analyze the tables? How do we do it?
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
