Answer Posted / jvdwhinfo

You are absolutely right Rathnakumar.
But we can also get the output by writing the query as
follows:
select replace('11111111ravi111111kumar11111',1,null) from
dual;
Anymore suggestions please let me know guys.

Thanks.
James

What is data caches/ index caches?

1169

---

Write the unconnected lookup syntax?

1129

---

What is the fact table?

1132

---

What is the function of look up transformation?

1173

---

What are the issues you have faced in your project? How did you overcome those issues?

2412

---

How do you promote a non-reusable transformation to reusable transformation?

1179

---

What is different between the data warehouse and data mart?

1112

---

What is mapping debugger?

1067

---

What are the main features of Oracle 8i with context to datawarehouse?

2158

---

What are mapplets?

1326

---

What are the guidelines to be followed while using union transformation?

1206

---

Explain transaction control transformation in informatica

1310

---

How to update or delete the rows in a target, which do not have key fields?

1220

---

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

2434

---

What is primary and backup node?

1171

---