Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Data Warehouse Job Interviews:Ab InitioActuateAnalysis ServicesBO DesignerBusiness ObjectsCognos Data WarehouseColdFusionCrystal Enterprise SuiteData IntegrationData ScientistData StageData Warehouse AnalystData Warehouse BIData Warehouse Data MartData Warehouse DeveloperData Warehouse ManagerData Warehouse SupervisorData Warehouses MicroStrategyData WarehousingData Warehousing BasicsDatabase PartitioningEnterprise Data WarehouseETL (Extract, transform, load)General DatawarehousingHyperionImpromptuInformatica Data WarehousingLead Data ScientistMicro StrategyOperational Data StoreReportnetSAS (Statistical Analysis System)Warehouse AssistantWarehouse ConceptsWarehouse DataStageWarehouse Operation ManagerWarehouse Worker
Copyright © 2018. All Rights Reserved
Data Warehouse Data Mart Interview Question:
What is data validation strategies for data mart v?
Submitted by: AdministratorData validation strategies are often heavily influenced by the architecture for the application. If the application is already in production it will be significantly harder to build the optimal architecture than if the application is still in a design stage. If a system takes a typical architectural approach of providing common services then one common component can filter all input and output thus optimizing the rules and minimizing efforts.
There are three main models to think about when designing a data validation strategy.
*Accept Only Known Valid Data
*Reject Known Bad Data
*Sanitize Bad Data
We cannot emphasize strongly enough that Accept Only Known Valid Data is the best strategy. We do however recognize that this isn't always feasible for political financial or technical reasons and so we describe the other strategies as well.
All three methods must check:
*Data Type
*Syntax
*Length
Submitted by: Administrator
There are three main models to think about when designing a data validation strategy.
*Accept Only Known Valid Data
*Reject Known Bad Data
*Sanitize Bad Data
We cannot emphasize strongly enough that Accept Only Known Valid Data is the best strategy. We do however recognize that this isn't always feasible for political financial or technical reasons and so we describe the other strategies as well.
All three methods must check:
*Data Type
*Syntax
*Length
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.