This discussion is archived
6 Replies Latest reply: Oct 16, 2012 1:54 PM by Andy Coates RSS

Insert records into W_EXCH_RATE_G table.

user12021881 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points