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

Answer / pawan

Fact: It is an object that is being analyzed.

Fact table: It consists of a composite key and facts, where ever attribute of the composite key is a foreign key to the dimension table or summarized information.

Two Types Of Fact Tables:
1) Cumulative Fact Table: Describes what was happened over the period of time. They contain addition facts.
2) Snap shot Fact Table: Deals with the particular period time. They contain non-additive and semi-additive facts.

Answer / chandrasekar

A Fact table contains unique combination of dimensional keys.
Fact tables are normalized.
A Fact tables have the facts at the lowest level of granularity.

Types of Fact table:
There are 3 types .
1)Detailed Fact table
2)Aggregate/Summarize fact table
3)Factless fact table

If it wrong means please send the correct answer to me
chandranmca2007@gmail.com

Answer / mural

i need example plz explain

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

permutations of mapplet

0 Answers   TCS,

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

Global and Local shortcuts. Advantages.

0 Answers  

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

performance wise which one is better in joiner and lookup transformation

2 Answers  

---