there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

---

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

What are the features of datastage flow designer?

0 Answers  

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---