Oracle Staging tables
722880Sep 16 2009 — edited Sep 16 2009Hi all,
I am new to OWB and have a doubt about the staging tables. I have a mapping from which I read a file, process it and load into the database. I want to introduce a new file (as a staging table) in this mapping from which someone can configure a list of numbers, and then the mapping will read those numbers and apply some logic. The file would look as follows:
2709
2708
2707
Someone can add numbers here and the mapping I have will read this file and apply the logic. My question is, if someone changes the mapping file above with this
2709
2708
2707
2710
Will the new (2710) number be considered or do I need to deploy the whole thing again?
Thanks in advance
G.