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

Define enterprise data warehousing?

0 Answers  

---

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

---

Briefly explain the aggregator transformation?

0 Answers  

---

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

What did you do in source pre load stored procedure

1 Answers  

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

What is the use of incremental aggregation?

2 Answers  

---

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  

---

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

---

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 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,

---