Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Loading Facts outside the ETL tool?

Go down

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

Post  nba411 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 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