Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 13396 Views
- TCS, I also Faced
- E-Mail Answers
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 repository manager?
How we can create indexes after completing the load process?
What is persistent lookup cache?
What are the new features of informatica 9.x in developer level?
What is sequence generator transformation in informatica?
What is the function of look up transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Why sorter is an active transformation?
Explain what transformation and how many are there in informatica?
Name the different lookup cache(s)?
What is the use of code page?
What do think which one is the better joiner or look up?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
how tokens will generate?
What are the data movement modes in informatica?
