Answer Posted / manohara reddy

view is logic and virtual table. it does't hold data.it
allows DML Operations.when ever u update or insert in base
table or view automatically changed those.
materialized view is static. u want create m.view DBA
Privileges and permissions must. it hold data all. when ever
u update or create rows in base table , it update only
update base table. doesn't change.

Which means the first record should come as last record and last record should come as first record and load into the target file?

1067

---

What are the new features of informatica 9.x in developer level?

991

---

What is the difference between source qualifier transformations source filter to filter transformation?

1041

---

What are the different types of repositories created using informatica?

1121

---

How to Create a folder using pmrep command?

1173

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2153

---

Which version configuration tool used in ur project?

3249

---

Can we create multiple integration service on single repository?

1184

---

Clarify the utilization of aggregator cache record?

990

---

Under which circumstances, informatica server creates reject files?

1082

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1061

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2351

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1624

---

Explain the etl program with few examples.

1046

---

Differentiate between sessions and batches?

1012

---