BusinessObjects Board

Match Transform and Target table

dataservices data quality
#1

Hi,

Experts please throw some light on the below situation. can Match transform help on this situation. Apologies if its an duplicated post.

I have input records coming from 5 different source systems orders, customers at different times i.e., some feeds are monthly some are daily some are quarterly. I will pick Customer as an example.

Source 1: ABCD: ADDR1:ADDR2:City:State:Zip
Source 2: ABCD: ADDR1:NULL:City:NULL:Zip
Source 3: ABCD: ADDR1:ADDR2:NULL:NULL:Zip

  1. Source 2 data prefers all other sources which is monthly
  2. Source 3 is daily every chance record will be loaded to prior to data available from Source 2
  3. If data available from Source 3 pick those fields but priority goes to source 3.

Is this possible through Match transform.

Thanks,

DI.net (BOB member since 2007-07-26)

#2

after you run through standardization, it will fix a lot of your last line gaps. Past that … as long as you’ve got your priority set for your different sources, its going to output the highest priority with group sequence #1, group rank M (master).

jlynn73 :us: (BOB member since 2009-10-27)

#3

I did run standardization on the source records. Best record scenario works if all records are coming at same time. How ever my situation here is Source records are coming at different times. So the prioritization should be done on records existing in DWH as well.

I was doing some research online can candidate selection in Match transform serve the purpose.

Thanks

DI.net (BOB member since 2007-07-26)