6 Replies Latest reply: Oct 16, 2012 3:54 PM by Andy Coates RSS

    Insert records into W_EXCH_RATE_G table.

    user12021881
      Hello Everyone,

      Can anyone help me with the following scenario.

      I would like to know how we could insert additional exchange rate record into W_EXCH_RATE_G table in the datawarehouse.
      I verified that the records populated in that table ate from PS_RT_RATE_TBL from peoplesoft.
      But I just have a flat file and I will have to populate the additional record.
      Can you let me know if I have to use and update query to do the same or should I modify the Informatica mapping?

      Thanks for the help in Advance!
      -Nikki