How can we do ETL process in SQL Server?
Answer / nilanjana
In Sql Server 2005 WE can use SSIS package from BIDS and
can do ETL process as per requirement. Earlier in Sql
server 2000 It was acheived by DTS.
Is This Answer Correct ? | 6 Yes | 0 No |
What is a look up function? What is default transformation for the look up function?
Explain what is the difference between a primary and secondary actor in use case modeling?
What is the very basic difference between data warehouse and operational databases?
What is Time Series algorithm in data mining?
what are different storage options supported by oracle ?
Explain what are non-additive facts?
How to create different types of templates?
What are components of reportnet?
Explain what is analytical or analytic mean?
Whether dimension table can have numeric value?
Explain what are the various reporting tools in the market?
How can we determine what records to extract?