What is DTS ?
Answer / azhar
DTS stands for Data Transfer Services. It was introduced in
sql server 7.0.
In sql server 2000 DTS was a bit advanced by adding
scripting like VB Scripting. Previously DTS was a wizard
kind of thing so now DBA's were finding it difficult to
write the scripts which was easily done by developers.In
2005 it came as Integration Service.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain piconet?
How we are using this function?
What are components of reportnet?
What is is a star schema?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain what is full load & incremental or refresh load?
Explain why dimenstion tables are denormalized in nature?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is the function of etl when used in data warehousing?
What is normalization, first normal form, second normal form, third normal form?
What are data modeling and data mining?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?