Answer / chanti

A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. Unlike an ordinary view, which does not take up any storage space or contain any data.

A materialized view can be stored in the same database as its base table(s) or in a different database.
Materialized views stored in the same database as their base tables can improve query performance through query rewrites. Query rewrites are particularly useful in a data warehouse environment.

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

What is target load order?

0 Answers  

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

Mention some types of transformation?

0 Answers  

---

---

What are the ETL tools available in DWH?

6 Answers   Mphasis,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

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

0 Answers  

---

Explain your project of banking domian.

0 Answers   Cap Gemini,

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---