No indexes
Excess recompilations of stored procedures.
Procedures and triggers without SET NOCOUNT ON.
Poorly written query with unnecessarily complicated joins
Highly normalized database design.
Excess usage of cursors and temporary tables.
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
What is Full load & Incremental or Refresh load?
How to determine what records to extract?
Do we need an ETL tool? When do we go for the tools in the market?
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
What are parameter files? Where do we use them?
How can we use mapping variables in Informatica? Where do we use them?
What is a mapping, session, worklet, workflow, mapplet?
What is Informatica Metadata and where is it stored?
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
