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

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

In development project what is the process to follow for an etl developer from day1

0 Answers  

Please let me know how to make encryption and decryption with example?

0 Answers  

Difference between task flow and linear task flow

0 Answers  

How many ways are there to create ports?

0 Answers   Informatica,




have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

How to display null values on a target & non-null values on a target?

3 Answers  

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

For more Informatica Interview Questions Click Here
Categories