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 |
Is there any difference in testing database and data ware housing?
what role views play in dimensional modeling?
How to import vsam files from source to target. Do we need a special plugin?
Tell me the Top 10 features of oracle that supports datawarehousing.
How to create prompts in report net?
What is execution plan?
Explain what are the tasks that loadmanger process will do?
Explain difference between data ware house & data mart?
Is there any default username & pwd for bo designer & supervisor?
What is meant by metadata in context of a data warehouse?
What are the key columns in Fact and dimension tables?
How to answer the question how many fakt table in your datawarehouse and what size it have?