Loading Facts outside the ETL tool?

Go down

Loading Facts outside the ETL tool? Empty Loading Facts outside the ETL tool?

Post  nba411 on Wed Jul 31, 2013 4:22 am

Hello all,

I have 4 dimensions: date, person, item, and warehouse. I'm loading an accumulated snapshot fact table, but unsure on how to proceed.

The sources and dimensions are already in the same Oracle environment. Can I populate the facts using SQL or should I be going through the ETL process (in my case Informatica)? I'm thinking I can just do join from source to the date dimension within Oracle to get the dim_date_keys and any necessary facts loaded as opposed to going through the ETL process. Is there a right or efficient way?

- Thanks

nba411

Posts : 8
Join date : 2013-06-27

Back to top Go down

Loading Facts outside the ETL tool? Empty Re: Loading Facts outside the ETL tool?

Post  ngalemmo on Wed Jul 31, 2013 11:04 am

Technically you can do anything you want. From a management and maintenance standpoint it becomes problematic if you use different methods to load different tables.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum