replace multiple spaces with single space.
- 3 Answers
- 5229 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pushpendra
replacechr function can use.
replacechr(0,Column_Name,' ','')
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / xx
Its always better to use reg_replace check the below link
https://etltechsolutions.wordpress.com/category/informatica/
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / kartik
Hops I ound Trip Time robe1
to
Hops I ound Trip Time robe1
| Is This Answer Correct ? | 0 Yes | 1 No |
i have 2 session s1 execute s2 load first session fail what is the reason?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
What do mean by local and global repository?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
what is the size of u r source(like file or table)?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
What are the issues you have faced in your project? How did you overcome those issues?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Teradata 
