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

Briefly describe lookup transformation?

0 Answers  

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

what is curr val use for in sequence generator?

2 Answers   Emphasis,

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

From where we can start or use pmcmd?

3 Answers  

When do you use sql override in a lookup transformation?

0 Answers  

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

How to eliminate duplicates from flat file..what is the procedure

4 Answers