How can we do ETL process in SQL Server?
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 to reduce warnings?
4.Explain Snowflkeschema ?
6 Answers EDS, HCL, IBM, iFlex, TCS,
Explain the versions of reportnet?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
what is the difference between MOLAP and ROLAP?
How many project sources we can create in metadata?
What is called data cleaning?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is difference between Mapplet and reusable transformation?
What are diagrams?
0 Answers InfoAxon Technologies,
What are the various methods of getting incremental records or delta records from the source systems?