Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 13438 Views
- TCS, I also Faced
- E-Mail Answers
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 rank transformation?
What is a pre-defined event and user-defined event?
Which are the different editions of informatica powercenter that are available?
How to do unit testing in informatica? How to load data in informatica ?
How to do the error handling of if ur source is flatfiles?
How to differentiate between the active and passive transformations?
What is meant by active and passive transformation?
Where can we find the throughput option in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the use of source qualifier?
How we can use union transformation?
How to update source definition?
Repository user profiles
What is the difference between router and filter?
