Answer Posted / anurag arun edlabadkar

Difference Between Inline View & Materialized View?

You can use Materialized views to pre-aggregate the data
and improve the query performance. When you create a
materialized view, Oracle created a physical table to hold
data that would usually be read via a view. When you create
a materialized view, you specify the view's base query as
well as a schedule for the refreshes of its data. You can
then index the materialized view to enhance the performance
of queries against it. As a result, you can provide data to
your user in the format they need, indexed appropriately.

A View is a database object that is a logical
Representation of of a table. It is derived from a table
but has no storage of its own and often may be used in the
same manner as a table.

What is the different lookup cache(s)?

1032

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1048

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1003

---

Why filter transformation is an active one?

928

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1194

---

Under which circumstances, informatica server creates reject files?

1025

---

what is Active lock explain

2724

---

can u any challenge your project?

1971

---

How to update or delete the rows in a target, which do not have key fields?

1115

---

what is degenerated dimension?

3870

---

What is the meaning of up gradation of repository?

1894

---

What is status code in informatica?

959

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1906

---

What are the guidelines to be followed while using union transformation?

1064

---

What is rank index in rank transformation?

1010

---