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

Explain where to store informatica rejected data? How to extract the informatica rejected data?

578

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1744

---

Explain transaction control transformation in informatica

761

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

637

---

what is the hint? how to use it to reduce the query processing in program?

6296

---

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1915

---

How do you load only null records into target? Explain through mapping flow.

1504

---

What you know about transaction control transformation?

556

---

What is the difference between writing a joiner query in ANSI style and THETA style?

1917

---

What is sequence generator transformation in informatica?

618

---

Explain the types of transformations?

596

---

Performance tuning in UNIX for informatica mappings?

2137

---

what is index?how it can work in informatica

1580

---

what is INFORMATICA TESTING process

1838

---

How can you generate reports in informatica?

577

---