Answer Posted / mallikarjun

There are 3 types of Schemas,
1.Star Schema
2.Snowflake Schema
3.Galaxy/Integrated/Hybride/Consalation Schemas
1)Star Schema-It is defined as the fact table is centrally located,surrounded by dimension tables is called star schema.In that dimension tables are denormalized and fact table is normalized.(or)Star schema is defind as two or more fact and two or more dimension tables that are related to foreigh keys.
2)Snowflake Schema-It is defind as the Denormalized Dimensions tables are can be splited into two or more normalized dimensions is called snowflake schema.In that both dimensions and fact tables are normalized.
3)Hybride Schema-It is defind as a dimension table is shared by two or more fact tables.

Is stop and abort are same in informatica?

946

---

What is Data Caches size?

1031

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1014

---

How can informatica be used for an organization?

1130

---

What is dimensional table?

1001

---

What is lookup transformation?

1001

---

Define sessions in informatica etl?

969

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1985

---

What's the layout of parameter file (what does a parameter file contain?)?

2333

---

Explain the mapping variable usage example in informatica

1080

---

what is SDLC way of code development?

1966

---

How do you handle two sessions in Informatica

1072

---

How to update source definition?

1030

---

What are the components of workflow manager?

1017

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4034

---