Gaza, a piece of our soul. ❤️🇵🇸
  • Lesson.No : 34
  • 00:08:10

  • 37 Using the MERGE Statement in data warehouse

  • Play

Course Lessons

  1. 1- 0 Course Layout
  2. 2- 1 Data Warehouse Overview
  3. 3- 2 DataWarehouse Terminology
  4. 4- 3 DataWarehouse Introduction
  5. 5- 6 Planing Data Warehouse Infrastructure
  6. 6- 7 Planning for High Availability for Integration Service
  7. 7- 8 Calculating Maximum Consumption Rate
  8. 8- 10 Data Warehouse Design Overview
  9. 9- 14 business intelligence Report Demo P1
  10. 10- 14 business intelligence Report Demo P2
  11. 11- 15 Designing Dimension Tables P2
  12. 12- 16 Import and Export SSIS Packages
  13. 13- 17 Explorer SSIS Packages usin Sql Server Data Tools
  14. 14- 18 Demo for Datawarehouse Indexing and cloumn store index to inhance performance
  15. 15- 18 Demo for Partitioning a Fact Table
  16. 16- 19 Demo for Datawarehouse Comperssing Data to inhance performance
  17. 17- 21 Introduction to ETL with SSIS
  18. 18- 22 Explorer Data Source
  19. 19- 23 Demo Implementing a Data Flow
  20. 20- 24 Demo Implementing a Control Flow
  21. 21- 19 Demo for Datawarehouse Indexing and cloumn store index to inhance performance P2
  22. 22- 25 Debug in SSIS شرح
  23. 23- 26 Debug and Error Handling in SSIS شرح
  24. 24- 27 Log SSIS
  25. 25- 28 Error Handle in SSIS
  26. 26- 29 Extract Data Planing
  27. 27- 30 Demonstration Using a Datetime Column
  28. 28- 31 Change Data Capture In Details
  29. 29- 32 Change Track In Data warehouse
  30. 30- 33 Data Loading Palning Data warehouse
  31. 31- 34 Load Data from CDC Output Tables to Data Warehouse
  32. 32- 35 Using the Lookup Transformation P1
  33. 33- 36 Using the Lookup Transformation P2
  34. 34- 37 Using the MERGE Statement in data warehouse
  35. 35- 40 Loading a Partitioned Table
  36. 36- 41 Script Task
  37. 37- 42 Deploying and Configuring SSIS Packages
  38. 38- 43 Implementing a Slowly Changing Dimension
  39. 39- 45 Data Quality Service Overview
  40. 40- 46 Demonstration Creating a Knowledge Base
  41. 41- 47 Demonstration Cleansing Data
  42. 42- 48 Demonstration Matching Data Using Data Quality Service
  43. 43- 49 Master Data Service Overview
  44. 44- 50 Master Data Service Overview P2