Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13179 Views
- TCS, I also Faced
- E-Mail Answers
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
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Design a mapping to load a target table with the following values from the above source?
How you prepared reports for OLAP?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain load alternative records / rows into multiple targets - informatica
Explain the mapping variable usage example in informatica
Differentiate between sessions and batches?
list out all the transformations which use cache?
What is informatica powercenter repository?
expain about the tune parameters?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the difference between source qualifier transformations source filter to filter transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Write the unconnected lookup syntax?
