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
What is workflow? What are the components of workflow manager?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the transformations that are not supported in mapplet?
What are the informatica performance improvement tips
scenario where i can use only concurrent execution of workflow.
Explain what is informatica metadata and where is it stored?
What is joiner transformation in informatica?
can u give example for factless fact table
what is size of u r database?
How to go to the older version for a mapping?
What is persistent lookup cache?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Performance tuning( what you did in performance tuning)
What are the performance considerations when working with aggregator transformation?
How to create a non-reusable instance of reusable transformations?