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

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---

How do you update the records with or without using update strategy?

0 Answers  

---

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

---

What is the capacity of power cube?

1 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

How to use Normalizer transformation?

2 Answers  

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---

Which development components of informatica have the highest usage?

0 Answers  

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---