Interested to Buy Any Domain ? << Click Here >> for more details...
replace multiple spaces with single space.
- 3 Answers
- 6338 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 |
Which is the t/r that builts only single cache memory?
Explain what transformation and how many are there in informatica?
wht is cdc?how to use it in creation of mappings?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
what is the significance of newlookup port in dynamic look up
How to convert multiple rows to single row (multiple columns) in informatica
What is meta data and system catalog?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
How many types of sessions are there in informatica.please explain them?
wat are deployement groups in informatica, how it will be used for developers
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
how to load dimension table and fact table. plz tell me the steps.
Teradata 
