Answer / ram pothineni

select replace('"TCS"MUMBAI"','"',' ') from tab;

Answer / bob

Repacechr(1,""TCS"MUMBAI",'"',null)

Answer / chanakya123

Dear Chow,thanks for ur reply, the SQ reading "" only from
""TCS"MUMBAI",the rest of the part truncated,then how can u
use ltrim and rtrim, i tried it creating a mapping.

Answer / ramesh

replacechar(columnname,instr(columnname,'"',1,2),' ')

the instr function finds the position of the char i.e. " in the second occurence and 'replacechar' replaces it with null.

Answer / chow

we can do using ltrim and rtrim and concat two words

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

what is the look up transformation?

2 Answers   Informatica,

---

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

---

What is source qualifier transformation in informatica?

0 Answers  

---

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

---

---

How do you convert single row from source into three rows into target?

0 Answers  

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

What are two types of processes that informatica runs the session?

2 Answers  

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

expain about the tune parameters?

0 Answers   TCS,

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---