I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?

Answers were Sorted based on User's Feedback



I have a source as flat file and having data like ""TCS"MUMBAI" and i want outp..

Answer / ram pothineni

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

Is This Answer Correct ?    13 Yes 3 No

I have a source as flat file and having data like ""TCS"MUMBAI" and i want outp..

Answer / bob

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

Is This Answer Correct ?    5 Yes 3 No

I have a source as flat file and having data like ""TCS"MUMBAI" and i want outp..

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.

Is This Answer Correct ?    0 Yes 0 No

I have a source as flat file and having data like ""TCS"MUMBAI" and i want outp..

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.

Is This Answer Correct ?    1 Yes 1 No

I have a source as flat file and having data like ""TCS"MUMBAI" and i want outp..

Answer / chow

we can do using ltrim and rtrim and concat two words

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,


2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,


What is DR strategy for Informatica project?

0 Answers  


what is junk dimension

4 Answers   Cap Gemini,


what is degenerated dimension?

1 Answers   IBM,


Explain transaction control transformation in informatica

0 Answers   Informatica,


How many repositories can be created in informatica?

1 Answers  


what is the size of ur database(like oracle)

2 Answers   HP,


How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,


While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  


get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,


How can you access the remote source into your session?

1 Answers  


Categories