SQL Server caches the plan of execution of query or stored procedure which it uses in subsequent call.
This is a very important feature with regards to performance enhancement.
You can view execution plan of data retrieval graphically or textually.
I am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done?
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?
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
