Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is isolation level and when do u use them?
- 1 Answers
- 21158 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 |
how to implement scd2 in datastage 7.5 with lookup stage
How many input links can you give to a Transformer stage?
what is advantages of snowflake when it is used?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
I have a few records just I want to store data in to targets cycling way how?
How to reverse the string using SQL?
what r the sources u need to create the datastage?
how to find diff between 2 dates without using Icon... funtions?
What is the method of removing duplicates, without the remove duplicate stage?
Enlist various types of routines in datastage.
How rejected rows are managed in datastage?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
Teradata 
