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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / guest

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 informatics server which files are created during the session rums?

0 Answers  

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

According to his methodology what all you need before you build a datawarehouse

0 Answers  

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

What do you understand by SOA of Informatica?

0 Answers  

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

For more Informatica Interview Questions Click Here
Categories