1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / chanakya123

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

Describe two levels in which update strategy transformation sets?

1 Answers  

How to delete duplicate row using informatica?

0 Answers  

How many number of sessions can one group in batches?

0 Answers  

What is aggregate awareness?

1 Answers  

what is mystery dimension?

1 Answers  




Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

What is dimensional table?

0 Answers  

what is datamart

4 Answers   IBM, Informatica,

What is an Integration service in Informatica?

0 Answers  

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

Define informatica repository?

2 Answers   Wipro,

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories