Sponsored Links


Results 1 to 1 of 1

Thread: CS614 Data Warehousing Solution May 20,2010

  1. #1
    Senior Member viki's Avatar
    Join Date
    May 2010
    Posts
    2,132

    Post CS614 Data Warehousing Solution May 20,2010

    Sponsored Links


    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.

    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.



    ANSWER

    . 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

    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

    (1) ETL
    Extract, Transform, Load in which data transformation takes place on a separate
    Transform server.

    (2) ELT
    Extract, Load, Transform in which data transformation takes place in the data ware
    House server.
    Combination of both that is ETL and ELT is also possible

    Sponsored Links
    Last edited by viki; 05-21-2010 at 04:07 AM.
    :o:o--------------------------------------------------------------------------------------:o:o
    [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]
    [B]http://vuhelp.net/groups/birthday-wishing.html[/B]
    [B]http://vuhelp.net/groups/daily-hadees.html[/B][/CODE]
    [CENTER][B][COLOR="Red"][SIZE="4"]Email: [email]viki@vuhelp.net[/email][/SIZE][/COLOR][/B][/CENTER]

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 08-02-2014, 02:45 PM
  2. Replies: 1
    Last Post: 11-20-2011, 05:47 PM
  3. Replies: 0
    Last Post: 01-14-2011, 05:45 PM
  4. Replies: 0
    Last Post: 11-13-2010, 03:19 AM
  5. Replies: 0
    Last Post: 11-13-2010, 03:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
-: Vuhelp Disclaimer :-
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator's or staff of Vuhelp.net cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms. If you have any doubts about legality of content or you have any suspicions, feel free to contact us.
Online Education | JhelumSoft