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.

How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

---

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

how to sort two columns in single job in datastage.

0 Answers   TCS,

---

why we use hash file for lookup?

5 Answers  

---

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

---