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 cube in data warehousing concept?
What is data type of the surrogate key?
Explain Process flow in data warehouse??
How to create context?
Explain some of modeling tools available in the market?
5.Explain ODS ?
What are vaious etl tools in the market?
What is Star Schema?
What are the different problems that ?Data mining? can solve?
Explain dimension table ?
Why we use repository connectivity?
How Materialized Views are linked with Oracle DataWare house?