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 SDLC way of code development?

2091

---

What is primary and backup node?

1174

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1311

---

What are pre and post-session shell commands?

1388

---

How does the aggregator transformation handle null values?

1193

---

What is the way to execute pl/sql script using informatica mapping?

1681

---

How many input parameters can exist in an unconnected lookup?

1601

---

Explain lookup transformation is active in informatica

1148

---

How you can differentiate between connected lookup and unconnected lookup?

1105

---

How to create Target definition for flat files?

1283

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2510

---

Differences between connected and unconnected lookup?

1271

---

How to improve the performance of a session using sorter transformation?

1187

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10321

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1846

---