Dimension Build Updates

[c6lapsteel]

Hi,

Is it possible to update tables in a dimension build only if the data is NOT null or blank?

Thanks,

[Opher]

Not sure if you are still waiting for a reply...but here goes:

You would create your Dimension using a data stream and in the SQL filter out any null or blank records.  The remaining rows would flow normally.

Good luck,
Opher

[c6lapsteel]

Hi Opher,

Thanks for your suggestion. Actually I'm trying to deal with the situation where I have several different data sources for the same Dimension, some of which may be incomplete. In order to reduce admin overhead, I'm trying to reuse as many builds as possible.

Let's say I have a Customer record:

Customer Code,
Customer Name
Market
Country
Salesrep
... etc

In some cases the Market data is missing. But I don't want to filter out the record altogther in the SQL select - if it contains Salesrep data I want to make sure the most up-to-date value is pulled through. Ideally I want my Dimension update to update only those fields which are not missing or null ... which would require building the SQL Update statement dynamically of course.

Regards,
c6

[rmcleod]

Why dont you place a replacement value in missing or null data and then it wont be a problem -