insert into TBL_DEALS(external_id, user_id, deal_date, ccy, amount)
select
	d.id as external_id,
	d.user_id,
	strToDate(d.deal_date, 'YYYYMMDD') as deal_date,
	left(d.amount, 3) as ccy,
	toDblGeneric(d.amount) as amount
from STG_DEALS d