Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NULL mapping

User_CO3C0Jan 24 2019 — edited Jan 27 2019

Hi All,

We are on PBCS and using data management to load data to application.I have a condition for one of the dimension (Customer) like

when we get NULL's for customer I have to IGNORE else i have to load so I am not sure how to specify this condition in data load mapping.

I know i can mention this condition if I want to ignore a specific record for example if customer_id is some number then i can use like mapping and mention IGNORE but how to match NULLS which re coming from source?

I can use SQL script but that works only when i wanted to map NULL's to specific member of application/dimension.

NOTE: IGNORE is not a member in the outline , I just want that record to be ignored.

Thanks in advance

Added on Jan 24 2019

#business-intelligence-applications, #financial-data-management, #performance-management-applications

7 comments

1,159 views