Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is isolation level and when do u use them?
- 1 Answers
- 20975 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 |
what is the definitions for Datawarehose and Datamart?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
1)How to Duplicate Records Delete in Sequential file?
how to write server Routine coding?
What is the use of datastage designer?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
what is diff b/w datastage 8.1,8.5,8.7?
What is the difference between datastage and datastage tx?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
How to read multiple files using a single datastage job if files have the same metadata?
How to delete the data in dataset?types of deleting the data in dataset?
Teradata 
