Answer / deepthi

1.Refreshing of data is possible in materialised views. we
can restrict rows of data for acces from other users in
materialised views.

above mentioned two points are not possible with table.

Thanks
Deepthi

Answer / chandra

TABLE: A TABLE IS HAVING ALL THE COLUMS DATA

WHERE AS

MATERILIZED VIEW : HAVING SELECTED COLUMS DATA WHICH R
DEFINED IN VIEW

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

---

what is unique constraint error ?

2 Answers   TCS,

---

What are the transformations that are not supported in mapplet?

0 Answers  

---

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

Can we create two repositories on same database instance in oracle?

0 Answers  

---

WHAT IS FACT TABLES?

2 Answers  

---

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

---