Answer / kiran

Its Related to Informatica

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,

---

What is a range lookup?

2 Answers   IBM,

---

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

What are the functionalities of link collector?

0 Answers  

---

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

---

How do you reject records in a transformer?

0 Answers  

---

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

Can you filter data in hashed file?

0 Answers  

---