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 is depict expression change?

1118

---

lookup transformation with screenshots

4005

---

I have a flat file, want to reverse the contents of the flat file

1126

---

What is the benefit of session partitioning?

1116

---

What are the types of lookup transformation?

1077

---

What are connected or unconnected transformations?

1122

---

What are some examples of informatica etl programs?

940

---

What are the various types of transformation?

1179

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2179

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1081

---

How can you increase the performance in joiner transformation?

1190

---

Explain sessions?

1056

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1262

---

What do think which one is the better joiner or look up?

1203

---

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

4109

---