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 a sequence generator transformation?
What is a sorter transformation?
What is informatica metadata and where is it stored?
What are the different transaction levels available in transaction control transformation?
What is domain and gateway node?
What is event and what are the tasks related to it?
Parameter and variable differences
What is the difference between stop and abort in informatica
How can we create index after completion of load process?
How to create or import flat file definition in to the warehouse designer?
Differences between version 7.x and 8.x.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is repository manager?
What is a router transformation?
Explain the code page compatibility?