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.

How do you create surrogate key using ab initio?

0 Answers  

---

What is difference macros and prompts?

0 Answers  

---

If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?

1 Answers   CSC,

---

What are aggregate tables and aggregate fact tables?

0 Answers  

---

What is Grain & Granularity in Data Warehouse.

2 Answers   TCS, TVS,

---

Difference between PowerPlay transformer and power play reports?

0 Answers   CTS,

---

Explain the data types present in bo n wht happens if we implement view in the designer n report?

0 Answers  

---

What is the 4 + 1 view model as it relates to system modeling?

0 Answers  

---

What is a general purpose scheduling tool?

0 Answers  

---

What are session timeout and application timeout?

0 Answers  

---

In datastage can ve find the job based on source table name ??

1 Answers   TCS,

---

How can we do ETL process in SQL Server?

1 Answers   ETL,

---