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
Answer / ram pothineni
select replace('"TCS"MUMBAI"','"',' ') from tab;
Is This Answer Correct ? | 13 Yes | 3 No |
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 |
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 |
Answer / chow
we can do using ltrim and rtrim and concat two words
Is This Answer Correct ? | 0 Yes | 4 No |
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?
What is DR strategy for Informatica project?
what is junk dimension
what is degenerated dimension?
Explain transaction control transformation in informatica
How many repositories can be created in informatica?
what is the size of ur database(like oracle)
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
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
How can you access the remote source into your session?