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

What do you understand by SOA of Informatica?

979

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7047

---

What is a repository manager?

1087

---

list out all the transformations which use cache?

1180

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1950

---

How to generate sequence numbers?

1082

---

What are data-driven sessions?

1193

---

What is a snowflake schema?

990

---

What are the types of schemas we have in data warehouse.

952

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1042

---

What does command task mean?

1137

---

What do you mean by blocking transformation?

1033

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1851

---

How might one distinguish in the case of mapping is right or not without associating session?

1098

---

What is status code in informatica?

1015

---