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
- 2533 Views
- Virtusa, I also Faced
- E-Mail Answers
Unix command to view the data in a dataset
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what is a message handler
What is the difference between operational data stage (ods) and data warehouse?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how to abort the job its matain duplicates?
What are the partition techniques available in your last project?
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
Define repository tables in datastage?
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
Teradata 
