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
Can we create a Integration service without a Repository service and vice versa?
Explain direct and indirect flat file loading (source file type) - informatica
What are the static cache and dynamic cache in informatica?
Explain the different lookup methods used in informatica?
What are the data movement modes in informatica?
What is the use of transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain in detail scd type 2 through mapping.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to start a workflow using pmcmd command?
What are the types of caches in lookup?
Is stop and abort are same in informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the difference between source qualifier transformations source filter to filter transformation?
While migrating the data from one environment to another environment how would you manage the connections?