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?
Answer Posted / ram pothineni
select replace('"TCS"MUMBAI"','"',' ') from tab;
Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What is the difference between STOP and ABORT options in Workflow Monitor?
Under which circumstances, informatica server creates reject files?
What are pre and post-session shell commands?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What do you understand by term role-playing dimension?
what is the size of u r source(like file or table)?
What is Index Caches size?
How can you generate reports in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are ETL Tools?
How to update source definition?
COM components can be used in Informatica
How can we update a record in the target table without using update strategy?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Sequence generator, when you move from develoment to production how will you reset