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 flag 4 in update strategy t/r

6 Answers  

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

What do you mean incremental aggregation?

0 Answers  

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

how many types of dimensions are available in informatica?

0 Answers  

From where we can start or use pmcmd?

3 Answers