Answer Posted / p.suneetha roy
A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables as primary key present in Fact table for the
uniqueness and foriegn keys coming from dimension tables
referring to fact table. Fact tables contain texture data
and section.
There are 4 types of facts :
1)Additive
2)Non Additive
3)Semi additive facts
4)Factless fact.
Let me know if there are any more facts.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to generate sequence numbers?
What are the different lookup cache(s)?
Define enterprise data warehousing?
Briefly define a session task?
What is the need of an ETL tool?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain load alternative records / rows into multiple targets - informatica
scenario where i can use only concurrent execution of workflow.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can u generate reports in Informatica?
What is primary and backup node?
Explain how to import oracle sequence into informatica?
How many transformations can be used in mapplets.
What is sequence generator transformation in informatica?
