I was wondering if somebody could help me with probably something relatively easy. I would like to use https://api.fixer.io/latest to add some currencies into my Date Warehouse. I would like to add them row by row so in a table like ( currency CHAR(4), value REAL). Is this possible with the JSON Input? Or should I go for a table like (AUD REAL, USD REAL, JPY REAL) and than break it down later with a transformation?
Thanks in advance.