Answer Posted / roshan

apart from all the above answer one more difference is:
suppose we delete a table then all the views becomes invalid but this is not the case with the materialized view. its most interesting feature is auto commit refresh...

What is native users?

1177

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1039

---

Enlist the differences between database and data warehouse.

1131

---

Which transformation is needed while using the Cobol sources as source definitions?

1181

---

What is joiner transformation in informatica?

1055

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1135

---

Can we create multiple integration service on single repository?

1199

---

What all join we can perform in LOOKUP transformation?

994

---

What is meant by pre and post session shell command?

1169

---

Is it possible to revert a global repository to local one and why?

1091

---

What are some examples of informatica etl programs?

953

---

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

7090

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1644

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1690

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1137

---