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
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
what is the size of u r source(like file or table)?
what is the difference between informatica6.1 and infomatica7.1
what is $$$$?
What is the format of informatica objects in a repository?
Where is metadata stored?
what is unit testing?tell me proceedure
Which is the t/r that builts only single cache memory?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the different options available for update strategy?
pmscmd startworkflow -sv
On which transformations you created partitions in your project?
Explain the difference between a data warehouse and a data mart?
Explain direct and indirect flat file loading (source file type) - informatica
What is a transaction control transformation?