1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / raj


there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,co..

Answer / nikky

full table scane, no index will work

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How do u view log file for a particular job?

6 Answers   HP,

what is the main difference between sorragate key n primary key in one word

2 Answers  

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

types of errors in datastage?

2 Answers   Reliance,

Define repository tables in datastage?

0 Answers  




how to unlock a locked job in datastage 8.0

3 Answers   HCL,

How to initialize environment variables?

4 Answers   Infosys,

Define Merge?

0 Answers  

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

What are the repository tables in datastage?

0 Answers  

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,

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

For more Data Stage Interview Questions Click Here
Categories