Interested to Buy Any Domain ? << Click Here >> for more details...
replace multiple spaces with single space.
- 3 Answers
- 6336 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 |
How can we update a record in the target table without using update strategy?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
What is a shortcut and copy in Informatica and how two are different with each other?
What is rank transformation?
what is the function of 'F10' informatica ?
How can you run a session without using server manager?
how we can do session partition in informatica any one explain me clearly? thanks advance.
How to recover the standalone session?
What are the popular informatica products?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
Teradata 
