Hallo everyone,

I want to load a csv-file via LOAD command in to my staging table. There are 2 columns in the csv-file with these values:

"Bounce Rate";"Total Time"
"5.36%";"1 day 00:04:49"
"4.78%";"23:07:58"

I need to load these values in my staging table, which will need to be processed to put the final values in the fact table.

What is the best practise to do this?

I assume:
1. First step would be just loading the values just like they originall look like
2. Processing these values via SQL to get the wanted values.

For the table in the staging table, should I declare the column Bounce Rate and Total time with varchar?

Thank you for the help.

Regards,

Ratna