What is DTS and purpose of DTS ?



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

Post New Answer

More Oracle General Interview Questions

How do I learn what codesets are available in oracle?

0 Answers  


A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 Answers  


Whats the benefit of dbms_stats over analyze?

0 Answers  


what is view?

7 Answers   Accenture,


How to use fetch statement in a loop?

0 Answers  






How to display the hierarchy of employee and managers without using connect by prior.

1 Answers  


What is a subquery?

0 Answers  


Difference between inner join vs where ?

0 Answers  


what is the syntax of DROP command?

10 Answers  


How to resolve name conflicts between variables and columns?

0 Answers  


Where do we use decode and case statements?

0 Answers  


What is a lookup table in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)