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...


What is the procedure to load the fact table.Give in
detail?



What is the procedure to load the fact table.Give in detail?..

Answer / dr.journalist

Fact table basically consists of Foreign keys which are
taken from the primary keys of all dimension as well as
facts.
So, for this reason take all the dimensions as Unconnected
lookups and try to take the foreign keys and at the same
time try to use the avaialble sources and make all possible
facts with the necessary transformations.

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Informatica Interview Questions

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,


Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  


What is source qualifier?

6 Answers   SDS,


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


What is InformaticaPowerCenter?

0 Answers   Informatica,


Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  


How can we eliminate duplicate rows from flatfile,explain?

3 Answers  


Why you use repository connectivity?

3 Answers   Yash Technologies,


In which scenario did you used pushdown optimization?

1 Answers  


in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,


Categories