DataWarehouse

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi there,

Let' look at the following scenario:

Database A with a Customer table, PK ID#.
Database B with a Customer table, PK ID#.

Both Database A & B are 2 different system and not related.
However, same Customer may exists in both system.

Now, I would like to create a common Customer info in another database.
With a DateTime field, I can get the latest record from either system with
the PK ID#.

But, if System A updates Tel No for Customer John on 30/10/2006.
And System B updates Address only for the same Customer John on 31/10/2006.

By taking the lastest data i.e. from System B is not entirely correct.
Because System A has the new Tel No.

Is there a way to check which Field is updated??? Or any suggestion?

regards,
Boon



.

Relevant Pages

  • Re: Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... > UDQ Services has years of experience with MS Excel and VBA (Visual Basic ... > templates, spreadsheet applications, and database applications. ... > P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.worksheet.functions)
  • Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.programming)
  • Spreadsheet/VBA Consulting - 50% Off or Even Free
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.misc)
  • Spreadsheet/VBA Consulting - 50% Off or Even Free
    ... UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... templates, spreadsheet applications, and database applications. ... P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.newusers)
  • Re: Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... >> UDQ Consulting Services Believes that Every Problem Should Have an Easy & ... >> templates, spreadsheet applications, and database applications. ... >> P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.worksheet.functions)