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 logic will you implement to load data into a
fact table from n dimension tables?

Answers were Sorted based on User's Feedback



what is the logic will you implement to load data into a fact table from n dimension tables?..

Answer / ranjeet

does this question have any sense, I don't think so

Is This Answer Correct ?    9 Yes 3 No

what is the logic will you implement to load data into a fact table from n dimension tables?..

Answer / satyaranjan

Always load data from dimension to fact is incremental load

Is This Answer Correct ?    6 Yes 2 No

what is the logic will you implement to load data into a fact table from n dimension tables?..

Answer / vikaskrmails@gmail.com

fist of all, Fact and Dimensions are separate entity tables
because fact contains measures and PK and FK where as Dim
contains Detail data along with PK and FK.
Dimensions and fact's loaded by their different sources
first we load dimensions and simultaneously assigned it to
surrogate key by sequence or CSUM etc functions. dimension
can maintain FK for other related dimensions and facts.
after loading fact we are updating it with Dim's PK-FK by
lookup.

Is This Answer Correct ?    4 Yes 2 No

what is the logic will you implement to load data into a fact table from n dimension tables?..

Answer / elango

fact table should contain all foreign key (PK) of the
dimensional tables, and it should be measured based on the
measures in the fact table as per the client specification.

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,


In a table, 4 person having same salary. How to get Third person record only?

15 Answers  


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

1 Answers   Puma,


What is the scenario which compels informatica server to reject files?

0 Answers  


source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  


What is primary and backup node?

0 Answers  


In target table how to display the system time

1 Answers  


What is Data Caches size?

0 Answers   Informatica,


what is the process of target load planing?

2 Answers   IBM,


What are Rapid changing dimensions?

1 Answers  


Categories