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

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,


Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,


What is intricate mapping?

0 Answers  


What are the databases that informatica can connect to windows?

0 Answers  


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  


what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,


4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,


How to elaborate powercenter integration service?

0 Answers  


Explain about cumulative Sum or moving sum?

0 Answers   Informatica,


how to delete duplicate records by using filter transfermation?

3 Answers  


What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,


Categories