How do we measure progress in Data Integration?

Correct Answer: Following are the data integration factors: - Sub set of the available data should be optimal - Noise/distortion estimation levels because of sensory/processing conditions at the time of data collection - Accuracy, spatial and spectral resolution of data - Data formats, storage and retrieval mechanisms - Efficiency of computation for integrating data sets to reach the goals

Correct Answer: Following are the benefits of data integration: - Makes reporting, monitoring, placing customer information across the enterprise flexible and convenient - Data usage is efficient - Cost Effective - Risk adjusted profitability management as it allows accurate data extraction - Allows timely and reliable reporting, as data quality is the prime technology for business challenges

Correct Answer: - The process of combining data from different resources - The combined data is provided to the users with unified view - Information from different enterprise domains are integrated ? known as Enterprise Information Integration - Useful for merging information from different technologies among enterprises - The sub areas of data integration are 1 Data Warehousing 2 Data Migration 3 Master Data Management

Correct Answer: - Scheduling and executing the batch jobs - Configuring, starting and stopping the real-time services - Adapters configuration and managing them - Repository usage, Job Server configuration - Access Server configuration - Batch job publishing - Real-time services publishing through web services

Correct Answer: NO_CACHE ? It is used for not caching values PRE_LOAD_CACHE ? Result column preloads and compares the column into the memory, prior to executing the lookup PRE_LOAD_CACHE is used when the table can exactly fit in the memory space DEMAND_LOAD_CACHE ? Result column loads and compares the column into the memory when a function performs the execution DEMAND_LOAD_CACHE is suitable while looking up the highly repetitive values with small subset of data

Correct Answer: - UDAI places the data in the source systems - A set of views are defined for providing access the unified view to the clients / customers - Zero latency of data can be propagated from the source system - The generated consolidated data need not require separate storage space - Data history and version management is limited and applied only to the similar type of data - Accessing to the user data overloads on the source systems

Correct Answer: - Physical Data Integration is all about creating new system that replicates data from the source systems - This process is done to manage the data independent of the original system - Data Warehouse is the example of Physical Data Integration - The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases - A separate system is needed for handling vast data volumes

Correct Answer: Visual Foxpro was part of Visual Studio 60 It was excluded in the Net version and was released as an independent programming language

Correct Answer: Optimized code tends to run faster and make more efficient use of the system?s resources Optimized codes are also less susceptible to errors and take lesser space in memory and in file size

Correct Answer: The letters XP actually stands for eXPerience It was designed as an enhancement of Windows 2000, with a totally different and more attractive user interface/console