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 a parameter When and where do you them when does the value will be created

0 Answers  

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

What are the reusable transformations?

0 Answers   Informatica,

---

Types of error logs in Informatica?

2 Answers  

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

what is mapping override?

2 Answers   Cap Gemini,

---

What is informatica? Why do we need it?

0 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,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  

---