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
- 11615 Views
- TCS, I also Faced
- E-Mail Answers
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
How do you load first and last records into target table?
What is workflow? What are the components of workflow manager?
Is it possible to revert a global repository to local one and why?
What is rank transform?
What is data transformation manager process?
is it possible to index the data in cache of lkp transformation ?
What happens when a session fails and you click on recover?
scenario where i can use only concurrent execution of workflow.
Explain target update override in informatica
What is lookup change?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are the issues you have faced in your project? How did you overcome those issues?
What is dimensional table? Explain the different dimensions.
Explain what is informatica metadata and where is it stored?
What is deployment group?
