Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact and what types of fact tables is there
- 4 Answers
- 11226 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Fact: It is an object that is being analyzed.
Fact table: It consists of a composite key and facts, where ever attribute of the composite key is a foreign key to the dimension table or summarized information.
Two Types Of Fact Tables:
1) Cumulative Fact Table: Describes what was happened over the period of time. They contain addition facts.
2) Snap shot Fact Table: Deals with the particular period time. They contain non-additive and semi-additive facts.
| Is This Answer Correct ? | 3 Yes | 0 No |
A Fact table contains unique combination of dimensional keys.
Fact tables are normalized.
A Fact tables have the facts at the lowest level of granularity.
Types of Fact table:
There are 3 types .
1)Detailed Fact table
2)Aggregate/Summarize fact table
3)Factless fact table
If it wrong means please send the correct answer to me
chandranmca2007@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
What are teh different tasks that can be created in workflow manager?
sorce is a flatfile only 1st and last row should insert to target how will u do?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
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
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
How to load data in informatica ?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
Why touse stored procedure in ETL Application?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
What are the various types of transformation?
Teradata 
