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.

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9980

---

What are junk dimensions?

1021

---

Explain the shared cache and re-cache?

1051

---

Explain sessions and how many types of sessions are there?

957

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1088

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2032

---

In informatica workflow manager, how many repositories can be created?

1271

---

How many ways are there to create ports?

1236

---

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?

1431

---

What do you mean by worklet?

1017

---

Differentiate between reusable transformation and mapplet.

1030

---

How an expression transformation differs from aggregator transformation?

993

---

What are the components of Informatica? And what is the purpose of each?

983

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1995

---

Explain the features of connected and unconnected lookup.

876

---