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 many-to-many dimensional model in datawarehousing ?
What is the difference between snowflake and star schema?
what are different storage options supported by oracle ?
How can you clear the cache?
What is a source qualifier?
What are the differences between star and snowflake schema?
Explain swot analysis?
Where the cache files stored?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what is a view as it relates to system modeling?
Explain the difference between view and materialized view?
What are data validation strategies for data mart validation after loading process?
What is perform recovery?
Do you view contain data?
What is metadata in context of a datawarehouse and how it is important?