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
Enlist some properties of sessions.
What is a joiner transformation?
differences between service based and product based?
What is status code in informatica?
How to load data in informatica ?
what is index?how it can work in informatica
What do you mean by blocking transformation?
What is a connected transformation?
What is substr in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
During the running session, output files are created by informatica server. Enlist few of them.
What are pre and post-session shell commands?
What is the benefit of session partitioning?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Differences between connected and unconnected lookup?