Answer Posted / sujana

it updates the row in the cache r leaves it unchanged

What is exclusive and normal mode for repository services?

1124

---

Describe an informatica powercenter?

1108

---

What is the procedure for creating independent data marts from informatica 7.1?

1046

---

How can we remove the duplicates from flat file source?

1004

---

What is a shortcut and copy in Informatica and how two are different with each other?

1186

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1936

---

What is informatica worklet?

1034

---

How many numbers of sessions can one group in batches?

1051

---

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

1039

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2026

---

What is the need of an ETL tool?

1072

---

Define update strategy?

1195

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1024

---

list out all the transformations which use cache?

1166

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2228

---