Question :

What is fact less fact table? where you have used it in your project?

» Oracle Database » Oracle Extract transform load (ETL)

Question Published at Thursday, 20 May 2010 in Category Oracle ETL. Question Visited: 1988 Times.

Answer of Selected Question

	Download Oracle ETL Interview Questions And Answers PDF

Answer(s):

Fact less table means only the key available in the Fact there is no measures available.

factless fact table means that contains only foreign keys with out any measures example:attendance report of employees in a particular company contains no measures only

Previous Interview Question	Next Interview Question
What are snapshots? What are materialized views & where do we use them? What is a materialized view?	Can we look-up a table from source qualifier transformation. ie. unconnected lookup?

« previous12 3 4 5 6 7 8 next »

Do you find this Answer incorrect or incomplete? Please e-mail us or place your comment or if you have correct answer then place in comment regarding above question. To ensure quality, each change is checked by our team, before it enters the main website database. If you desire so, the changes will be credited to your name.

Subscribe your email to receive free updates:

Enter your email address and get free web tutorials, job hunting tips, career advices, job vacancies and interview questions updates directly delivered to your email inbox

Hot Oracle ETL Frequently Asked Questions

►	How can we use mapping variables in Informatica? Where do we use them?

►	What is partitioning? What are the types of partitioning?

►	What is fact less fact table? where you have used it in your project?

►	What is a mapping, session, worklet, workflow, mapplet?

►	Can we look-up a table from source qualifier transformation. ie. unconnected lookup?

Hot Oracle ETL Frequently Asked Questions

Hot Interview Categories in Oracle

►	Oracle Database Frequently Asked Interview Questions and Answers

►	Oracle DBA Frequently Asked Interview Questions and Answers

►	Oracle PL-SQL Frequently Asked Interview Questions and Answers

►	Oracle GL Frequently Asked Interview Questions and Answers

►	Oracle ETL Frequently Asked Interview Questions and Answers

Comments (On What is fact less fact table? where you have used it in your project?)

Your email is required but won't be published any where else. Personal information will be kept confidential; we do not sell or release private information.

Webmaster Said:

Jun 18 2013

Your comments will be instantly published after webmaster review. All visitors can submit their comments on What is fact less fact table? where you have used it in your project? no registration is required to post your comments. You are welcome to share your ideas, experiences, suggestions questions and answers, but please be respectful of others when commenting. Insulting, self-promotional, website promotion, marketing, SEO Techniques, SMS-style and off-topic comments will not be published. Share your comments regarding What is fact less fact table? where you have used it in your project?
Thank you.

Rate this Interview Question and Answer page by placing your comments here please...

Feel Free To Leave Your Comment

What is fact less fact table? where you have used it in your project?

HTML Rendering of above code:

[ Free Web Directory ] [ Global Web Forum ] [ Contact ] [ Links ] [ Site Map ] [ Statistics ] [ Services ] [ Privacy ]
Learn [ HTML ] [ XML ] [ JavaScript ] [ CSS ] [ SQL ]