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
- 11991 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
Tell me about Propagate functions in informatica
What are mapplets?
What is exclusive and normal mode for repository services?
How to delete duplicate row using informatica?
What is an unconnected transformation?
What is source qualifier transformation in informatica?
Briefly describe lookup transformation?
How can you increase the performance in joiner transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What are the prerequisite tasks to achieve the session partition?
What are the mapping parameters and mapping variables?
Explain the different lookup methods used in informatica?
What is a joiner transformation?
What do you understand by term role-playing dimension?
What is a node in Informatica?
