Loading Facts outside the ETL tool?

View previous topic View next topic Go down

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

View user profile

Back to top Go down

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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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