1 Reply Latest reply: Dec 28, 2012 10:57 AM by CL RSS

    How to optimize Flat file to Flat file dataload thru ODI, where query is in


      I am trying to load data thru flat file in essbase, my flat file consist 7 columns among which only 2 are needed as one of the two signifies my account dimension and other one carries a string of 6 dimensions. following process is followed.

      1. created a staging file which will bifurcate my column carry 6 dimension members.
      2. in that staging file directly mapped account.
      3. created variables for year and period.
      4. in the final interface i mapped members directly to dimensions like version and scenarion

      Note : i have a total of 14 dimensions.

      Swarnima Mandloi.