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

Briefly explain the aggregator transformation?

0 Answers  


What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,


"Change cache" in Informatica ?

2 Answers  


How to elaborate tracing level?

0 Answers  


Is it possible to create multiple domains on a single Informatica server?

0 Answers  


what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,


I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  


What is event and what are the tasks related to it?

0 Answers  


Different sorts of metadata that stores in the storage facility?

0 Answers  


If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,


Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,


what are the deliverables?in your project?

0 Answers   DELL,


Categories