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
Explain your project of banking domian.
can anyone explain me about retail domain project in informatica?
How to configure mapping in informatica?
What is a filter transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain the different lookup methods used in informatica?
Can we create a Integration service without a Repository service and vice versa?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the different components of powercenter?
What is update strategy transform?
What are mapplets?
Differentiate between Load Manager and DTM?
What is a standalone command task?
What is the surrogate key?
What is expression transformation?