Answer Posted / harshakore

A view has a logical existence but a materialized view has
a physical existence.Moreover a materialized view can be
indexed,analysed and so on....that is all the things that
we can do with a table can also be done with a materialized
view.

What is sorter transformation?

1108

---

can we override a native sql query within informatica? How do we do it?

1186

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1530

---

What is a repository? And how to add it in an informatica client?

1192

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1557

---

What is pmcmd command?

1180

---

define galaxy repository in informatica

2285

---

What does command task mean?

1215

---

What are the differences between oltp and olap?

1018

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1915

---

What are junk dimensions?

1111

---

What is the use of transformation?

1053

---

What is a joiner transformation?

1035

---

Design a mapping to load a target table with the following values from the above source?

1394

---

What are the prerequisite tasks to achieve the session partition?

1295

---