Answer / 24/12/2007

it contains only measurable values or datas

Answer / gp

The table contain measurable data(facts) is called fact
table .

These facts defined three types : Additive

Non Additive

Semi additive facts

Answer / m.sivakumar

The centralized in a star schema is called fact table.
fact table have two types of columns.
facts
foreign keys to dimension tables.
fact tables are three types
1)additive
2)non-additive
3)semi additive

Answer / honey

A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables. Fact tables contain data that describes specific
events within a business, such as bank transactions or
product sales.

Answer / 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.

Answer / bhargavi

Fact table contains facts or measurements(numeric values)
of the business

Answer / 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

Answer / shyam

Dimension table contains the textual information to analyse
the business. It contains more number of column as compare
the less no. of rows.

There are the four types of dimention table in the
Datawarehousing.
1. Confirmed Dimension
2. Shared Dimension
3. Degenerated Dimension
4. Jun Dimension.

Answer / amit

fact table is collection of all facts in the dimension
facys is nothing but quantitative data

Whats there in global repository

0 Answers  

How to load duplicate records in to a target table which has a primary key?

2 Answers  

What is hash partition?

1 Answers  

What is factless fact schema?

1 Answers  

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

How to display null values on a target & non-null values on a target?

3 Answers  

What are the databases that informatica can connect to windows?

0 Answers  

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.

3 Answers  

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,