Master DATA DUPS

[Stevennn]

Im using one data source with 3 data bases. How and where in Decision Stream i can load only unique account numbers?

Thank-you for your Help!

 

[mfgf]

Hi,

How about a data source that reads:

SELECT DISTINCT account_number FROM your_table

Or is there some more complex problem?

MF.

 

[Stevennn]

I can do this if i have one data base, but i'm pulling from 3 data bases. Data Base 1, 2, 3 might have te same accounts. So if i put DISTINCT that will only apply to one data base?! But I would like to load all 3 data bases into one table without dups accounts.

Than you for your responce!

 

[mfgf]

Hi,

As long as the account_number is defined as the only Dimensional build element in the Transformation Model, you can turn on Merging for the build (go to the properties of the build and you will find the merge option on the Input tab) or reject the duplicates (again on the input tab).

Be aware that if multiple rows are merged, the default is to sum the measure values of these rows into a consolidated total. If you want to do something different with the measures, go the the property of each measure build element in the Transformation Model and change the merge behaviour on the Merge tab.

Regards,

MF.