Answer Posted / seshagiri
DTS is set of graphical tools and programmable objects,
using that we can extract,transform, and consolidate data
from source in to multiple destinations.
Tasks are....
Transform Data
Copy and Manage Data
Function as Jobs
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain intellisense for query editing
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is scheduled job and how to create it?
What is a dataset and what are the different types of datasets?
Explain what is the function of sql server agent windows service?
We need to perform what steps in the following order to work with a cursor?
How to execute the cursor queries with "open" statements?
What is entity data services?
How important do you consider cursors or while loops for a transactional database?
What are the advantages of having an index on the sql server?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is proper subset of candidate key?
What is postgresql server?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What are the parts of a function?