Answer Posted / hania

Star Schama : easy for users to understand, optimize navigation and more suitable for query processing, and works faster.

Disadvantages: Dimension table have greater rows, large fact table

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1618

---

Explain about cumulative Sum or moving sum?

1023

---

How do you load alternate records into different tables through mapping flow?

1836

---

What is a router transformation?

1106

---

tell me 5 session failure in real time how can you solve that in your project?

2272

---

How can you increase the performance in joiner transformation?

1181

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1184

---

Explain the types of lookup transformation?

1035

---

What is fact table? Explain the different kinds of facts.

1064

---

what is index?how it can work in informatica

2030

---

What is a sequence generator transformation?

1002

---

How do you take back up of repository?

1143

---

How many dimensions are there in informatica?

1068

---

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

2032

---

What is dynamic cache?

1021

---