Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is isolation level and when do u use them?
- 1 Answers
- 21091 Views
- HP, IBM, I also Faced
- E-Mail Answers
Answer / ram
Specifies the transaction isolation levels that provide the
necessary
consistency and concurrency control between transactions in
the job and
other transactions for optimal performance.
Because Oracle does not
prevent other transactions from modifying the data read by
a query, that
data may be changed by other transactions between two
executions of the
query. Thus, a transaction that executes a given query
twice may
experience both nonrepeatable reads and phantoms. Use one
of the following
transaction isolation levels:
Read Committed. Takes exclusive locks on modified data and
sharable locks
on all other data. Each query executed by a transaction
sees only data
that was committed before the query (not the transaction)
began. Oracle
queries never read dirty, that is, uncommitted data. This
is the default.
Serializable. Takes exclusive locks on modified data and
sharable locks on
all other data. It sees only those changes committed when
the transaction
began plus those made by the transaction itself through
INSERT, UPDATE,
and DELETE statements. Serializable transactions do not
experience
nonrepeatable reads or phantoms.
Read-only. Sees only those changes that were committed when
the
transaction began. This level does not permit INSERT,
UPDATE, and DELETE
statements.
| Is This Answer Correct ? | 2 Yes | 3 No |
In Datastage, how you can fix the truncated data error?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
Can you explain players in datastage?
what is a force compile
What is RCP
Describe the architecture of datastage?
What are the various kinds of containers available in datastage?
what is the use of materialized view?
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
Tell me Wt main advantage of Stage varibles? Project level hints?
what is the use of skid in reporting?
Teradata 
