Interested to Buy Any Domain ? << Click Here >> for more details...
Explain factlessfact table with scenario
- 1 Answers
- 3449 Views
- HCL, I also Faced
- E-Mail Answers
Answer / tamilarasan
Factless fact table - it doesn't have any measures
There are types in this
Additive : we can calculate all the aggregate function in this
Semi: we can do only particular calculation
Non : no calculation can be done
| Is This Answer Correct ? | 0 Yes | 0 No |
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the difference between view and materialised view?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
difference between source based commit? and target based commit? which is better with respect to performance?
What is rank index in rank transformation?
How do you set a varible in incremental aggregation
What are the main features of Oracle 8i with context to datawarehouse?
Briefly define a session task?
major difference between normal loading and bulk loading?
How to prepared lld.can any one tell me detailed explanetion.
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
Teradata 
