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

Can any one give me an example for factless fact table ?
If your answer is studunt attendence registration,could you
plese give me explanation for this ?

Question Posted / cmanojkumar

Answers were Sorted based on User's Feedback



Can any one give me an example for factless fact table ? If your answer is studunt attendence regis..

Answer / jaspreet banga

Practical senario would be in a bank where you want to list
the customer information(customer dimension), Branch
information (Branch Dimension),Joining date (Date
Dimension) and the scheme (loan or deposit or current
account) they have taken in the Bank. So the Fact less fact
table would be Branch Key,Customer Key, Date Key, Account
Key (or Product or scheme Key).These all are foriegn key,
The balance you have is the fact which may or may not be
there, i.e., if you have null balance then it is fact less
fact tables

Is This Answer Correct ?    4 Yes 1 No

Can any one give me an example for factless fact table ? If your answer is studunt attendence regis..

Answer / sridhar

factless fact table is a fact table but table does n't have
any facts for measurement for e.g student attendance in a
class, if we have 100 members in a class we can perform the
calculations like marks,grades but you cannot measure for
student attendance.

Is This Answer Correct ?    2 Yes 1 No

Can any one give me an example for factless fact table ? If your answer is studunt attendence regis..

Answer / sridhar

factless fact table is a fact table but table does n't have
any facts for measurement for e.g student attendance in a
class, if we have 100 members in a class we can perform the
calculations like marks,grades but you cannot measure for
student attendance.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

Can you start a batches with in a batch?

1 Answers  

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

What is a mapplet/worklet in informatica?

0 Answers  

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

What is synonym?

2 Answers   Patni,

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

Define update strategy?

0 Answers  

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories