Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  


what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  


Explain constraint based loading in informatica

0 Answers   Informatica,


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,


we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,


I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,


What is a passive transformation?

0 Answers   Informatica,


WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,


How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,


how many types transformations supported by sortedinput?

4 Answers  


Categories