Total Comparison

[gatorfe]

Hello, currently there is a build that list a sales person and their customers from the erp system and gets dumped into sql server.  The list does not change often but I want to know when a new sales person/customer combo is introduced. Any suggestions on how this can be done?  Thanks in advance for your time.

[MFGF]

You could build a lookup based on the SQL Server table your fact build is populating (ie the sales person/customer details already delivered) and include a literal value of "EXISTING" in the lookup, then validate the fact build against this.  Use the option "Allow unmatched member identifiers" so that the new combos do not get rejected, and add a Transformation Model derivation to grab the literal from the lookup. Rows you deliver will then either have "EXISTING" or <null> in this column so you can determine the new combos.

Regards,

MF.