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

How can we delete duplicate rows from flat files?

756

---

To import the flat file definition into the designer where should the flat file be placed?

683

---

What do you mean by filter transformation?

565

---

What is a connected transformation?

686

---

What are the databases that informatica can connect to windows?

595

---

---

Why do you use Mapping Parameter and mapping variable?

1298

---

How many ways a relational source definition can be updated and what are they?

592

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

644

---

What are the different types of repositories created using informatica?

671

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1635

---

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

1569

---

What is the benefit of partitioning a session?

645

---

Define enterprise data warehousing?

642

---

write a query to retrieve the latest records from the table sorted by version(scd)

641

---

Enlist some properties of sessions.

640

---