Skip to Main Content
Forums

increase source value column limit in FDMEE data load mapping

JanGLiNov 23 2018 — edited Nov 26 2018

Hi,

I am creating FDMEE  data load mapping but unfortunately my source value contains nearly 100 letters

E.g

PHARMA - AMBER - STANDARD BOTTLES 60 ML (25 PP) RING BROWN 73GM-FURNACE-6 MANUFACTURED

When i try to create explicit data load mapping manually it removes the extra letters and my mapping becomes like this

PHARMA - AMBER - STANDARD BOTTLES 60 ML (25 PP) RING BROWN 73GM-FURNACE-6 M

pastedImage_5.png

I tried increasing srckey limit in these tables...

TDATAMAP_STG

TDATAMAP_T

TDATAMAPSEG

TDATAMAP

but still can't enter complete value in explicit mapping.

Kindly guide if this is do-able and if yes is it recommended to change structure of standard tables without oracle knowing?

Hyperion Planning 11.1.2.4.008

FDMEE 11.1.2.4.220

Linux 6.6

Our source is custom table

Regards
Comments
Post Details
Added on Nov 23 2018
#business-intelligence-applications, #column, #data, #fdmee, #financial-data-management, #hyperion, #load, #mapping, #performance-management-applications, #planning
3 comments
125 views