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
What are the steps involved in the migration from older version to newer version of Informatica Server?
What could be the possible resons of locks by user?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
EXL informatica Questions
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain sql transformation in script mode examples in informatica
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the use of transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Which development components of informatica have the highest usage?
What is a sorter transformation?
Explain what transformation and how many are there in informatica?
What is workflow monitor?
What is Session and Batches?
Different sorts of metadata that stores in the storage facility?