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

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

---

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

---

What is informatica etl tool?

0 Answers  

---

which quality process u can approach in ur project

1 Answers   CTS,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---