Skip to Main Content
Forums

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!

ODI - Issue with handling null value

user12073767Dec 3 2010 — edited Feb 21 2011
Hi,

I have a flat file as below. When i am trying to load the data file into Essbase through ODI, i am not able to load. If i given the Null value as 0, i'm able to load the file into Essbase. If we pass 0 in place of null value, blocks will be created in Essbase and it might cause the performance issue.

Account,Product,Customer,Version,Year,BU,Data
A1,P1,C1,V1,2010,BU1,7677
A2,P2,C2,V2,2010,BU2,0908
A3,P3,C3,V1,2010,BU3,

Can any one help if there is any way to handle the null values to load the data into Essbase?

Your help is more important to us as it is one of the critical one we are facing.

Thanks
V D Reddy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2011
Added on Dec 3 2010
#business-intelligence-applications, #data-integrator, #system-management-and-integration
4 comments
907 views