Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?

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

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  


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

0 Answers  


what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,


Explain what is informatica metadata and where is it stored?

0 Answers  






HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  


i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,


What is aggregator transformation in informatica?

0 Answers  


write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,


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 best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


What is the difference between Normal load and Bulk load?

5 Answers  






Categories