loading facts from dimensions in Informatica

View previous topic View next topic Go down

loading facts from dimensions in Informatica

Post  praneethbobba on Sat Jan 28, 2012 8:25 pm

Hi all,

I'm Praneeth . I'm new to data warehousing. I'd been working on Informatica for the last two weeks.I'm familiar with almost all transformations.But I'm facing problem when loading fact table from dimension tables.
Could you help me in knowing the right process to load facts and dimensions && facts from dimensions.

Thanks in advance,
Praneeth.
avatar
praneethbobba

Posts : 2
Join date : 2012-01-28
Age : 27
Location : Visakhapatnam

View user profile http://www.bi997.n.nu

Back to top Go down

Re: loading facts from dimensions in Informatica

Post  ngalemmo on Sun Jan 29, 2012 5:02 am

What do you mean by 'facts from dimensions'?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: loading facts from dimensions in Informatica

Post  praneethbobba on Sun Jan 29, 2012 9:05 pm

Hi Nick ,

The meaning behind ' facts from dimensions ' is as illustrated.

Consider EMP table in oracle.I've created two dimensional tables 'time' and 'dept'. My fact is 'Number of employees joined on a particular date or in a particular dept or both'. So now I need to populate the fact table with my time_key,dept_key and count of employees (that can be obtained from source). So I would like to know the right process to populate these dimensional tables, and later the fact table using the dimensional tables and the source.

P.S : Each table used here is a table in ORACLE database.

Thanks,
Praneeth.
avatar
praneethbobba

Posts : 2
Join date : 2012-01-28
Age : 27
Location : Visakhapatnam

View user profile http://www.bi997.n.nu

Back to top Go down

Re: loading facts from dimensions in Informatica

Post  BoxesAndLines on Wed Feb 08, 2012 2:21 pm

Load your dimensions, then your facts.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: loading facts from dimensions in Informatica

Post  Sponsored content


Sponsored content


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