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
- 13568 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 size of u r database?
What is decode in static cache?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is substr in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How can informatica be used for an organization?
How might one distinguish in the case of mapping is right or not without associating session?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to do the error handling of if ur source is flatfiles?
What is persistent lookup cache?
Explain about cumulative Sum or moving sum?
What is the reusable transformation?
Have you worked with/created Parameter file
What are the different ways to implement parallel processing in informatica?
In which transformation you cannot drag ports into it?
