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 / bob
Repacechr(1,""TCS"MUMBAI",'"',null)
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How union transformation is used?
What does update strategy mean, and what are the different option of it?
What are the different lookup cache(s)?
Whats there in global repository
Different sorts of metadata that stores in the storage facility?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
permutations of mapplet
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
difference between informatica 8.1.1 and 8.6
Explain direct and indirect flat file loading (source file type) - informatica
How many ways a relational source definition can be updated and what are they?
what is the complex transformation you used in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the transformations that are not supported in mapplet?