0 Replies Latest reply: Nov 29, 2009 8:07 AM by 737670 RSS

    ODQ Cleasing Project

    737670
      Hi everyone,

      I am working in oracle data quality and I have got this situation:

      1. A Customer file with the following schema (CUSTOMER_ID, CUSTOMER_TYPE, CUSTOMER_GROUP);
      2. A Contact file with the following schema (CUSTOMER_ID, CONTACT_NAME, CONTACT_SURNAME);

      The Customer and Contact entities are related by CUSTOMER_ID field. I would like to create a cleasing project that "merge" the entities in one entity. I will show you an example:

      CUSTOMER (ENTITY Data Input 01)
      -----------------------------------------
      CUSTOMER_ID CUSTOMER_TYPE CUSTOMER_GROUP
      1 C B
      2 C B


      CONTACT (ENTITY Data Input 02)
      -----------------------------------------
      CUSTOMER_ID CONTACT_NAME CONTACT_SURNAME
      1 ANDREW JUNIOR
      2 TOMAS HELVEG

      The result it must be:

      CUSTOMER_CONTACT
      ----------------------------------------
      CUSTOMER_ID CUSTOMER_TYPE CUSTOMER_GROUP CONTACT_NAME CONTACT_SURNAME
      1 C B ANDREW JUNIOR
      2 C B TOMAS HELVEG


      Could anyone help me to fix it, please?

      Thanks in advance!

      franto