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 / ramesh
replacechar(columnname,instr(columnname,'"',1,2),' ')
the instr function finds the position of the char i.e. " in the second occurence and 'replacechar' replaces it with null.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how we can load rejected record's at run time?(not through bad files)
What is informatica? Why do we need it?
Parameter and variable differences
How to extract sap data using informatica?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How we can create indexes after completing the load process?
How to generate sequence numbers using expression transformation?
How to create Target definition for flat files?
What are the issues you have faced in your project? How did you overcome those issues?
What is a surrogate key?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are different types of transformations available in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you load first and last records into target table?