Answer / naveen kumar reddy

LOADING FACTS

The most important thing about loading fact tables is that
first you need to load dimension tables and then according
to the specification the fact tables.

The fact table is often located in the center of a star
schema, surrounded by dimension tables. It has two types of
columns: those containing facts and other containing foreign
keys to dimension tables.

* A typical fact table consists of: Measurements:
additive-measures that can be added across all dimensions ,
non-additive cannot be added and semi-additive can be added
across few dimensions.
* Metrics
* Facts - The fact table has frequently more than one
measurement field and then each field is called a fact.
Usually one fact table has at least three dimension tables.



Note:
Found this answer at http://www.etltools.org/loading/facts.html

Answer / venkat

If all dimention tables are succeded then only you can load
data in to the facts.if any one of the dimention is not
filled you cannot load data into the fact tables.Fact table
size can be calculated based on the lowest level
granularity of dimention tables.

What is A cache?

2 Answers  

---

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

how i will stop my workflow after 10 errors

1 Answers   HP,

---

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

---