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

loading facts from dimensions in Informatica

Go down

loading facts from dimensions in Informatica Empty loading facts from dimensions in Informatica

Post  praneethbobba 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.
praneethbobba
praneethbobba

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

http://www.bi997.n.nu

Back to top Go down

loading facts from dimensions in Informatica Empty Re: loading facts from dimensions in Informatica

Post  ngalemmo Sun Jan 29, 2012 5:02 am

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

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

http://aginity.com

Back to top Go down

loading facts from dimensions in Informatica Empty Re: loading facts from dimensions in Informatica

Post  praneethbobba 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.
praneethbobba
praneethbobba

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

http://www.bi997.n.nu

Back to top Go down

loading facts from dimensions in Informatica Empty Re: loading facts from dimensions in Informatica

Post  BoxesAndLines Wed Feb 08, 2012 2:21 pm

Load your dimensions, then your facts.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

loading facts from dimensions in Informatica Empty Re: loading facts from dimensions in Informatica

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


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