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 / chow
we can do using ltrim and rtrim and concat two words
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What are the features of complex mapping?
What are the differences between oltp and olap?
tell me 5 session failure in real time how can you solve that in your project?
Different circumstance which drives informatica server to expel records?
what are the Methods For Creating Reusable Transformations?
What is the Process to creating lookup transformation in informatica
Could you explain what is enterprise data warehouse?
What are the uses of etl tools?
What is the use of code page?
What will be the approach?
What are the performance considerations when working with aggregator transformation?
lookup transformation with screenshots
How can one identify whether mapping is correct or not without connecting session?
Describe expression transformation?
How can repository reports be accessed without sql or other transformations?