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

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

What are the new features in Informatica 5.0?

1 Answers  

explain different levels in pushdown optimization with example?

2 Answers   TCS,

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

What are the rank caches?

2 Answers   Informatica,

Where do we use mapping variables in informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories