Informatica - Where exactly dimension and fact tables are useful? Is it source or target?We are importing source d

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 51 of 301

Where exactly dimension and fact tables are useful? Is it source or target?
We are importing source directly from database and transforming and loading the data to target.
Can anybody please send where they exactly it is useful?

Total Answers and Comments: 3

Last Update: October 10, 2006 Asked by: sree

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 03, 2006 13:42:22

raj

RE: Where exactly dimension and fact tables are useful...

when u doing analysis this will be use full. how u r taking decesions? depends on reports so dimentions and fact tables use full in reporting.

Is this answer useful? Yes | No

August 21, 2006 22:22:43

samba

RE: Where exactly dimension and fact tables are useful...

Dimesions and fact tables are nothing but tables

Dimesions and facts are targets for the mappings

first u have to load the data into dimensions these are called master tables after that by using transaction tables and master tables you have to populate the data into fact table.

let me know if you have any clarifications

cheers

samba

Is this answer useful? Yes | No

October 10, 2006 12:53:34

rajani

RE: Where exactly dimension and fact tables are useful...

Can you explain with some examples?

Thanks.

Is this answer useful? Yes | No

Go To Top