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
Enterprise data warehouse your projects phase by phase explain?
without table how to come first record only in oracle?
What is a grid in Informatica?
What is sequence generator transformation in informatica?
What is mapping debugger?
What is rank transformation?
What is event and what are the tasks related to it?
What is the benefit of session partitioning?
What is the meaning of decode in informatica?
How to generate sequence numbers using expression transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How to update a particular record in target with out running whole workflow?
How do you set a varible in incremental aggregation
How do you update the records with or without using update strategy?
What is the advantage of informatica?