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 what is the limit to the number of sources and targets you can have in a mapping?
What is the main difference between star and snowflake star schema? Which one is better and why?
What is the difference between snowflake and star schema?
What is a general purpose scheduling tool?
Explain if a flat file cotains 1000 records how can I get first and last records only?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
In microstrategy, how can we direct the sql generated to use a specifc table?
Can decision tree be implemented using SQL?
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 are components of report studio?
How to design file watch jobs?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is the goal of optimizer?
Is there any rownum object from which we can do this?
What are the different problems that ?Data mining? can solve?