We shouldn't allow input from users during a transaction.
We shouldn't open transactions while browsing through data.
We should keep the transaction as short as possible.
We should try to use lower transaction isolation levels.
We should access the least amount of data possible while in a transaction.
What are 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?
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?
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
