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
- 1957 Views
- Virtusa, I also Faced
- E-Mail Answers
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
What is the difference between account and directory options ?
how to retrive the max(sal),deptno,empno in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how to find no.of records in sequntial file itself?
what is the Difference Between Datastage Server Edition and Parallel Edition?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
specify data stage strength?
how to capture rejected data by using join stage not for lookup stage. please let me know
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
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.
If you want to use a same piece of code in different jobs, how will you achieve this?
Teradata 
