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?
- 5 Answers
- 11994 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / bob
Repacechr(1,""TCS"MUMBAI",'"',null)
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How to join three sources using joiner?
Which is the t/r that builts only single cache memory?
Different sorts of metadata that stores in the storage facility?
What do you mean by worklet?
What are the types of caches in lookup?
Mention few advantages of router transformation over filter transformation.
What does refresh system mean, and what are its distinctive choice?
What could be the possible resons of locks by user?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How many ways are there to create ports?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the way to execute pl/sql script using informatica mapping?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Global and Local shortcuts. Advantages.
How can we use mapping variables in informatica? Where do we use them?
