Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is isolation level and when do u use them?
- 1 Answers
- 21162 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 RCP?
project Steps,hits, Project level HArd things,Solved methods?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
what are the different type of errors in datastage?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
What are iconv and oconv?
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
What is the difference between informatica and datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
Teradata 
