WHAT IS FACT TABLES?
Answers were Sorted based on User's Feedback
Answer / siva
Fact table contains facts,measures or numerical vlues. Foe
example if your business process is 'sales' then a
measurment of this business process contains name of the
product,price of product,location and date and time of the
product sales.It also contains foreign keys of all the
dimension tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rekha
Fact table is the primary table in the dimensional
modeling . the numerical performance of measures of the
business stored in fact table
mostly used facts ara numeric and additive
not every numeric is a fact ,but a numeric wich ara of type
key performance indicator is called fact
| Is This Answer Correct ? | 2 Yes | 0 No |
where does the default group roew in a router is stored what is the default size of memory in router
When the informatica server marks that a batch is failed?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
How to generate sequence numbers without using the sequence generator transformation?
What is an expression transformation?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
define galaxy repository in informatica
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
What is souce qualifier transformation it is active or passive