what is fact and what types of fact tables is there
- 4 Answers
- 9664 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / suresh
Fact:
Fact represents business measure.
Fact table:
A fact table is the primary table in a dimensional model where the numerical performance measurements of the are stored.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Enlist the various types of transformations.
What is the sequence generator transformation in informatica?
What is an expression transformation in informatica?
what is $$$$?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Performance tuning in UNIX for informatica mappings?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is dimensional table? Explain the different dimensions.
What is incremental aggregation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the data movement modes in informatica?
What are mapplets?
Explain lookup transformation in informatica
