DSXchange

Hi,
We have a small issue in loading the fact table. We are getting null values in certain dimensions like vehicle and driver, but when Amruta checked the same with Shabber, he said, that is a valid record, and we need to take that row into account (need not through in to reject). Following are the two solutions we have in mind to proceed further:



If the required source column is null, transform the same as NA and populate the surrogate key OR
If the required source column is null, transform the same as NULL or 0 (we can have NULL or 0 as a value in dimension), and populate the fact with appropriate surrogate key.

Hi Rajendran,

Pls remove your other posts on the same topic. It might be quite urgent but that does not mean you have to post the same topic thrice. Pls remove them. In this forum your posts gets answered within a day.

And you don't have to mention names here. You post your problem or the business logic you would like to implement.

Regards
--Rich