{"id":1784,"date":"2022-02-14T14:49:27","date_gmt":"2022-02-14T14:49:27","guid":{"rendered":"https:\/\/swatilathia.com\/?page_id=1784"},"modified":"2022-03-15T03:55:44","modified_gmt":"2022-03-15T03:55:44","slug":"one-mark-questions-2","status":"publish","type":"page","link":"https:\/\/swatilathia.com\/?page_id=1784","title":{"rendered":"One Mark Questions"},"content":{"rendered":"\n
  1. EDW stands for _____<\/li>
  2. What is Data Warehouse?<\/li>
  3. What is Data Warehousing?<\/li>
  4. List different Data Warehousing Tools<\/li>
  5. List characteristics of Data Warehouse<\/li>
  6. List types of Data mart<\/li>
  7. List 4 tiers of Data warehouse<\/li>
  8. What is First Party Data?<\/li>
  9. What is Second Party Data?<\/li>
  10. What is Third Party Data?<\/li>
  11. What is Independent Data Mart?<\/li>
  12. What is Dependent Data Mart?<\/li>
  13. What is Fact Table?<\/li>
  14. What is Dimension Table?<\/li>
  15. ___ type of data is stored in fact table<\/li>
  16. ___ type of data is stored in dimension table<\/li>
  17. Draw a logical model of Data Warehouse<\/li>
  18. Draw a physical model of Data Warehouse<\/li>
  19. ETL stands for _________<\/li>
  20. What is ETL?<\/li>
  21. CSV stands for ________<\/li>
  22. SSIS stands for _______<\/li>
  23. DTS stands for ______<\/li>
  24. DTSX stands for ______<\/li>
  25. BIDS stands for ________<\/li>
  26. SCD stands for ______<\/li>
  27. List different types of SCD<\/li>
  28. List types of Dimensions<\/li>
  29. SSMS stands for ______<\/li>
  30. List different Containers in SSIS<\/li>
  31. MDM stands for _____<\/li>
  32. CRM stands for_____<\/li>
  33. OLAP stands for ____<\/li>
  34. OLTP stands for _____<\/li>
  35. DSS stands for _____<\/li>
  36. SOA stands for _____<\/li>
  37. ROLAP stands for ____<\/li>
  38. MOLAP stands for ____<\/li>
  39. UID stands for _____<\/li>
  40. SSAS stands for _____<\/li>
  41. SSRS stands for _____<\/li>
  42. SSDT stands for ____<\/li>
  43. DQS stands for _____<\/li>
  44. BIML stands for _____<\/li>
  45. DQAF stands for _____<\/li>
  46. List architectural components of Data Warehouse<\/li>
  47. What is Data Flow?<\/li>
  48. What is Control Flow?<\/li>
  49. What is Data Cleansing?<\/li>
  50. What is Data Matching?<\/li>
  51. Auto correction & auto suggestion values are parts of _______ Cleansing<\/li>
  52. suggested & invalid values are parts of _____ Cleansing<\/li>
  53. List the components of Data Flow Task?<\/li>
  54. List different Event Handlers<\/li><\/ol>\n<\/body>","protected":false},"excerpt":{"rendered":"

    EDW stands for _____ What is Data Warehouse? What is Data Warehousing? List different Data Warehousing Tools List characteristics of Data Warehouse List types of Data mart List 4 tiers of Data warehouse What is First Party Data? What is Second Party Data? What is Third Party Data? What is Independent Data Mart? What is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"zakra_page_container_layout":"customizer","zakra_page_sidebar_layout":"customizer","zakra_remove_content_margin":false,"zakra_sidebar":"customizer","zakra_transparent_header":"customizer","zakra_logo":0,"zakra_main_header_style":"default","zakra_menu_item_color":"","zakra_menu_item_hover_color":"","zakra_menu_item_active_color":"","zakra_menu_active_style":"","zakra_page_header":true,"om_disable_all_campaigns":false,"footnotes":""},"class_list":["post-1784","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/swatilathia.com\/index.php?rest_route=\/wp\/v2\/pages\/1784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swatilathia.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/swatilathia.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/swatilathia.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swatilathia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1784"}],"version-history":[{"count":5,"href":"https:\/\/swatilathia.com\/index.php?rest_route=\/wp\/v2\/pages\/1784\/revisions"}],"predecessor-version":[{"id":2126,"href":"https:\/\/swatilathia.com\/index.php?rest_route=\/wp\/v2\/pages\/1784\/revisions\/2126"}],"wp:attachment":[{"href":"https:\/\/swatilathia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}