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
Explain reference cursor?
What are snapshots? What are materialized views & where do we use them?
Explain dimension table ?
What is Discover and Execute in XMLA?
What are the key columns in Fact and dimension tables?
Whether dimension table can have numeric value?
what are the other factors of the database on which the loading performance depend?
Explain what are the basic needs to join two sources in a source qualifier?
What is metadata in context of a datawarehouse and how it is important?
Explain what are components of reportnet?
Describe the differences between a data warehouse and data mart.
Explain multivalued dependency?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Where the cache files stored?
What function should we use to display the value entered or selected by a user in response to a prompt?
