what is the meant by Normalization and de-normalization?

2773

---

explain the methodology of Data Warehousing?(Polaries)

2087

---

what are the concerns of OLTP and DSS systems?

2512

---

what is data modeling?

2360

---

what is the difference steps for data modeling?

2661

---

what are the data modeling tools you have used?(polaris)

2051

---

what is the difference between cardinality and Nullability?

2999

---

what is Forward,Reverse and Re_engineering?

2283

---

how would u estimate the size of Aggregator transform data and index cache?

2484

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2942

---

how do u really know that paging to disk is happening while u are using a lookup transform?

2483

---

how do u set partition points in the mapping?

2306

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2091

---

what is pmrep command?

2490

---

Difference between flat files and relational sources?

2372

---