Interested to Buy Any Domain ? << Click Here >> for more details...
What is DTS and purpose of DTS ?
- 1 Answers
- 6971 Views
- TCS, I also Faced
- E-Mail Answers
Answer / hitendra yadav
DTS is (Data Transformation Services)- which is the wizard
or fuctionality in SQL Server for transfer data from one
database to other database for example load data from EXCEL
SHEET to oracle database or SQL Server database,means it is
basiclly used to transfer data.
| Is This Answer Correct ? | 7 Yes | 1 No |
Explain a data segment?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
what are steps for interface? where is exchange rate defined in which table?
how to see the data (in unix) using dataset in datastage?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what are the differen between key flexifild and discriptive fiexifild.
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
What is oracle instant client?
Differentiate between pre-select and pre-query?
How to use like conditions in oracle?
Oracle General 
