Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you
- 6 Answers
- 13369 Views
- I also Faced
- E-Mail Answers
Answer Posted / hema
The fact which is not having any measures(like Quantity)
are called factless fact .To track the events (like Bad
order )the factless fact are used in the Projects
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Briefly define reusable transformation?
What are the tuning techniques you applied during your last project
What are the measure objects?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is target load order?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the need of an ETL tool?
Differentiate between Load Manager and DTM?
scenario where i can use only concurrent execution of workflow.
What are the performance considerations when working with aggregator transformation?
What is meant by lookup transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the difference between Active and Passive transformation?
What is a difference between complete, stop and abort?
Explain the difference between a data warehouse and a data mart?
