Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2581 Views
- Virtusa, I also Faced
- E-Mail Answers
How rejected rows are managed in datastage?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
what is Audit table?Have u use audit table in ur project?
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
Which type of joins Merge stage can support?
What is RCP?
What is the use of Row generator stage?
What are the stages in datastage?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
What is the purpose of pivot stage?
Teradata 
