Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is isolation level and when do u use them?
- 1 Answers
- 20961 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 |
Difference between the Sequence and Sequencer in DS?
Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok
how many types of sorting the data in data stage?
Can we use target hash file as a lookup ?
Display all files which have size more 3KB in given directory/folder.
What are some prerequisites for datastage?
on how many columns we can perform aggregation in the Aggregator stage?
Wat is isolation level and when do u use them?
what is mapping lookup
what is the definitions for Datawarehose and Datamart?
How can u write exception handling in seq file????
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
Teradata 
