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 / chanakya123
Dear Chow,thanks for ur reply, the SQ reading "" only from
""TCS"MUMBAI",the rest of the part truncated,then how can u
use ltrim and rtrim, i tried it creating a mapping.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
What is workflow? What are the components of the workflow manager?
Differentiate between router and filter transformation?
What do you mean by worklet?
Explain constraint based loading in informatica
What are the different lookup cache(s)?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Define pmcmd command?
How you prepared reports for OLAP?
Define mapping and session?
Write the unconnected lookup syntax?
expain about the tune parameters?
Difference between Target-based loading and constraint-based loading?
What are the types of lookup transformation?
What is a grid in Informatica?