Answer Posted / 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 |
Post New Answer View All Answers
What is critical column?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What are aggregate tables and aggregate fact tables?
Explain what are data marts?
What are the fundamental elements of the data warehouse?
What is the difference between mapping parameter & mapping variable in data warehousing?
What are the steps involved in designing a fact table?
What are the mapping paramaters and maping variables?
what are relationships?
Explain what are fact, dimension, and measure?
what type of raid setup would you put your tx logs?
What are the data marts?
What is dimensional modelling?
Whether dimension table can have numeric value?
Which are the olap tools available that are supported by oracle?
