Answer / abhinaw prakash

When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.

Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.

Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

What are the tasks that source qualifier perform?

0 Answers   Informatica,

---

How will you update the row without using update statergy?

10 Answers   CTS,

---

What is the Hierarchy of DWH?

1 Answers  

---

Where is metadata stored?

0 Answers  

---

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

Explain how to import oracle sequence into informatica?

0 Answers  

---

what is data driven?

1 Answers  

---

What is IQD file?

1 Answers  

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

in oracle write query yourname+1 from dual

5 Answers  

---