Answer / ganesh kumar

SELECT SUBSTR('INDIA',LEVEL,1) AS INDIA FROM DUAL CONNECT BY
LEVEL<=LENGTH('INDIA');

TRY THIS QUERY IT WILL WORKS CORRECTLY.

Global and Local shortcuts. Advantages.

0 Answers  

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

what is mapping parameter?

2 Answers   Cap Gemini,

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

---

Implementation methodology

0 Answers  

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

---