How can we do ETL process in SQL Server?
- 1 Answers
- 6336 Views
- ETL, I also Faced
- E-Mail Answers
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 |
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
which automation tool is used in data warehouse testing?
Explain the difference between filter and conditin?
what is Materialized Views?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Explain what are the advantages of query studio compared to report studio?
What is the difference between junk dimension and degenerated dimension?
What are the key features of chameleon that separates it from other algorithms?
Which kind of index is preferred in DWH?
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 how many ways you create ports?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Teradata 
