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
- 13394 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 are the components of the workflow manager?
What is powercenter on grid?
Can we get 1st record through Informatica(without sequence number).
What is lookup change?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is lookup transformation?
Briefly describe lookup transformation?
What is Cognos script editor?
How many dimensions are there in informatica?
have u done any performance tuning? how u ll do?
Explain about Informatica server process that how it works relates to mapping variables?
How to Create a folder using pmrep command?
Where are the source flat files kept before running the session?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
