This discussion is archived
0 Replies Latest reply: Nov 29, 2009 6:07 AM by 737670 RSS

ODQ Cleasing Project

737670 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points