Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please

Hi, This is Ranadheer. How to load fact tables using
dimeension tables. Please anyone give me a answer with
example. Thanks in Advance.

Question Posted / ranadheer

1 Answers
3572 Views
I also Faced
E-Mail Answers

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a an..

Answer / rao

Firstly we have to load the dimension tables.from dimension
tables take the primary key reference and load the Fact table.
That mean if you have dimensions like product,branch,customer,
we load product id,branch id,customer id(only surrogate keys)
to fact table .later measure will be loaded.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Informatica Interview Questions

What is the need of an ETL tool?

0 Answers Informatica,

why dimenstion tables are denormalized in nature ?

3 Answers

How to delete duplicate row using informatica?

0 Answers

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers Polaris, Zensar,

Why we use lookup transformations?

1 Answers

wht is cdc?how to use it in creation of mappings?

6 Answers HSBC,

major difference between normal loading and bulk loading?

6 Answers

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers Puma,

Does an informatica transformation support only aggregate expressions?

0 Answers

What is a pre-defined event and user-defined event?