Answer Posted / saket

Separate VENKATESH ,101
Rajesh,102
Siva ,103 by using "||" as delimiter .


Then in the expression Divide the string Venkatesh ,101 intto two separate variable using string operation and output that two separate columns of the target

What is the sql query overwrite in source qualifier in informatica

611

---

What's the layout of parameter file (what does a parameter file contain?)?

1911

---

What could be the possible resons of locks by user?

657

---

I have a flat file, want to reverse the contents of the flat file

684

---

What is a stored procedure transformation?

607

---

---

What are the various types of transformation?

638

---

State the differences between sql override and lookup override?

613

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1889

---

What is data caches/ index caches?

607

---

What are the new features of Power Center 5.0?

1227

---

What is the Process to creating lookup transformation in informatica

577

---

Could you explain what is enterprise data warehouse?

550

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1964

---

Difference between Data and Index Caches?

646

---

How might you approve all mappings in the archive all the while?

596

---