What is Factless fact table ???
- 12 Answers
- 42908 Views
- Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / rajkumar bachu
A Fact table without measures(numeric data) for a column is
called Factless Fact table.
eg: Promotion Fact(only key value available in FT)
| Is This Answer Correct ? | 46 Yes | 4 No |
Post New Answer View All Answers
Difference between Data and Index Caches?
What is a grid in Informatica?
What is a rank transform?
what is the Default Source Option For Update Strategy Transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
where to store informatica rejected data? How to extract the informatica rejected data?
What is a surrogate key?
Why update strategy and union transformations are active? Explain with examples.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is a stored procedure transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How we can use union transformation?
How to generate sequence numbers without using the sequence generator transformation?
How to partition the Session?
What are ETL Tools?
