Which DBMS suits for DWH
Microsoft SQL Server
Can we loading data from Import and Export Data Wizard
Yes
In which ways we can save package
a. SQL Server
b. SQL Server Meta Data Services
c. Structured storage file
d. Visual Basic file
What happened when there is an error in package execution
All transactions rolled back