Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suren
Fact table contains measurement of information
Factless table contians with out any measure.
1.Additive : Additive fact table contains the summarized
data.
2.Non Additive : Non Additive fact table contains without
additve data.it contains only detail data
3.SemidAdditive: Semi additive fact table contains both the
summarized data as well as detial data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How are indexes created after completing the load process?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to do the error handling of if ur source is flatfiles?
Scheduling properties,whats the default (sequential)
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the new features of Power Center 5.0?
What are the tuning techniques you applied during your last project
What is the difference between STOP and ABORT options in Workflow Monitor?
How to go to the older version for a mapping?
what are 3 tech challenges/ common issues you face?
What is the maplet?
Briefly explain the aggregator transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What if the source is a flat-file?
can u give example for factless fact table
