Answer Posted / senthil

hi,
we already know basic restrictions of view and materialized
view,

view is a logical or virtual table it doesn't have data on
its own, but materialized view has a physical structure it
stores data in local machine or on its own.materialized view
can be refreshed automatically or manually. but in view, if
any changes happened in the base tables, we want to reflect
the same in the view means view has to issue the select
statement again to the database

Explain the different lookup methods used in informatica?

972

---

How can you define user defied event?

972

---

How can we delete duplicate rows from flat files?

1159

---

What are the new features of informatica 9.x at the developer level?

981

---

Differentiate between a repository server and a powerhouse?

1041

---

Explain the difference between mapping parameter and mapping variable?

976

---

What do you mean by worklet?

1014

---

How can we use batches?

958

---

where to store informatica rejected data? How to extract the informatica rejected data?

948

---

How to join three sources using joiner?

1028

---

What is a passive transformation?

1034

---

Explain sessions. Explain how batches are used to combine executions?

950

---

Mention a few design and development best practices for informatica?

929

---

What is informatica? Why do we need it?

1038

---

What is domain and gateway node?

1118

---