Skip to Main Content

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!

Leading zero getting dropped after mapping

ericeriksonOct 19 2015 — edited Oct 19 2015

Hi. Working with FDMEE 11.1.2.3.700. File comes in with several leading zeroes for the account dimension. Have a Jython script to keep only the last six digits and that works fine. Some of the accounts correctly still have leading zeroes, like 070000 and 041205, and I can see that in the source account column in workbench. The accounts then get mapped, either by explicit map to handle sign flips or * to * for passthrough. The accounts that are explicitly mapped come over properly: 070000 maps to 070000. But the accounts with leading zeroes going through the passthrough map are dropping the leading zero: 041205 goes through * to * but comes out as 41205.

Thoughts? Don't think we had this issue before patching to 700.

Eric

This post has been answered by ericerikson on Oct 19 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2015
Added on Oct 19 2015
1 comment
496 views