Note: All the Assignments Solution which are provided on vuhelp are just like helping material for the students, U must make the required changes in it.
View more random threads:
- ENG101 Assignment No.1 Discuss and Solution English...
- Pak 301 Assignment No1 Fall October 2010
- MCM 511 Theories of Communication Assignment No. 1 Fall...
- MTH202 Assignment No. 1 Spring 2012 Last Date 13 April
- CS507 Information System Assignment No.02 Solution and...
- MTH401 Assignment 4 Solution June 2010
- MGT301 Principles of Marketing Assignment 1 Solution May...
- MGT613 Production / Operations Management Assigment#1 Idea...
- Assignment No.1 (Course STA301) Spring 2010 May 4,2010
- CS304 Object Oriented Programming 5 Assignment 19 July 2010
Q No. 1
In your organization, assume that customer names and addresses are maintained in three customer files supporting three different source operational systems. Describe the possible entity identification problem you are likely to face when you consolidate the customer records from the three files. Write a procedure outlining how you propose to resolve the problem.
. When we will perform any sort of operations on these types of files may be duplication or replication of data occurs. The extent of quality may be more good in that file in which we are working and may be as as much in which duplication of data occurs. When we extract these types of files from the systems it shows us that one entry contain many fields and share many data from other files.
Solution for overcome problem is that:
(1) We need to rank source systems on a per data element basis.
(2) Take data element from source systems from highest rank basis where basically and truly the element exists.
(3) To maintain data integrity we need to follow data ranking rules too.
FOR THIS TWO APPROACHES CAN BE FOLLOWED
Extract, Transform, Load in which data transformation takes place on a separate
Extract, Load, Transform in which data transformation takes place in the data ware
Combination of both that is ETL and ELT is also possible
Last edited by viki; 05-21-2010 at 04:07 AM.
[B]The more knowledge you have, the greater will be your fear of Allah.[/B]
Please Join My [B]Group Vuhelp[/B][B], Birthday Wishing, Daily Hadees[/B] [CODE][B]http://vuhelp.net/groups/vuhelp.html[/B]
There are currently 1 users browsing this thread. (0 members and 1 guests)