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 a design?

1 Answers  

What is data movement mode in Informatica and difference between them?

0 Answers  

How do you do error handling in Informatica?

1 Answers  

Why sorter is an active transformation?

0 Answers   Informatica,

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

How do you take care of security using a repository manager

2 Answers  

what are the row and column separations in Flat Files

3 Answers   CTS,