comandos

//COMANDOS A CORRER NO SQL

// 1º ELIMINAR AS TABELAS DIM

delete from t_dim_customer;
delete from t_dim_date;
delete from t_dim_product;
delete from t_dim_promotion;
delete from t_dim_store;
delete from t_dim_time;

//2º commit
commit;

//3º fazer os execs (nao tenho a certeza se é false ou true)
exec pck_extract.main(false);
exec pck_transform.main(false);
exec pck_load.main(false,false);