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
Define filter transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Plz can any one say me how to get the informatica certification materials and dumps
Separate from a database, an information bazaar, and an information stockroom?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
In how many ways we can create ports?
What is a dimensional model?
What is the cumulative sum and moving sum?
difference between repository database and repository service?
What is update strategy transform?
What are the different ways to implement parallel processing in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain pmcmd command usage in informatica
What is Session and Batches?
What the difference is between a database, a data warehouse and a data mart?