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 is persistent lookup cache?
What are the differences between joiner transformation and source qualifier transformation?
How do you take back up of repository?
Explain the mapping variable usage example in informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Design a mapping to load a target table with the following values from the above source?
How can we use mapping variables in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
tell me about your project functionality
How can we remove the duplicates from flat file source?
How to update source definition?
Define Pmrep command?
What is the function of look up transformation?
What is meant by query override?