Can I change a specific column before 'data scraping' data is 'insert'?

[S_Sim]

1.data scrapping (output datatable = dt_rr)

2. connect

3. insert (input datatable = dt_rr)

4.excute query

5.excute query (Can I work with ‘insert activity’?)

because, currency_id => number(2,0)
so can’t in table

assuming that varchar2 is not available , only number(2,0)