What is DTS and purpose of DTS ?
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 |
Differentiate between TRUNCATE and DELETE?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Explain what does a control file contain?
How will you differentiate between varchar & varchar2?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Can we create index on views?
19 Answers CTS, Syntel, TCS,
What is an index associated with a constraint?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is materialized view in Oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How to use "for" statements in oracle?
what is primary key and foreign key when and where have to use