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 a code page?

1161

---

Where are the source flat files kept before running the session?

1061

---

waht type of interface is used for testing the data in informatica

2242

---

What is the use of source qualifier?

1118

---

How many number of sessions can one group in batches?

1147

---

Explain the use of aggregator cache file?

1240

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2334

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1221

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1090

---

What are the new features of informatica 9.x in developer level?

977

---

What are the main issues while working with flat files as source and as targets ?

1144

---

which one is better performance wise joiner or look up

1074

---

What are different types of transformations available in informatica?

979

---

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

1053

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2121

---