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 the difference between STOP and ABORT options in Workflow Monitor?
What is a dimensional model?
what is $$$$?
What is meant by active and passive transformation?
Explain target update override in informatica
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain what transformation and how many are there in informatica?
Which version configuration tool used in ur project?
What are the performance considerations when working with aggregator transformation?
What is informatica etl tool?
What is the meaning of up gradation of repository?
my source is junk data how will u remove that junk data by using unix please any one replay me
How can you validate all mappings in the repository simultaneously?
What is informatica powercenter repository?
Why union transformation is an active transformation?