Interested to Buy Any Domain ? << Click Here >> for more details...
replace multiple spaces with single space.
- 3 Answers
- 6486 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 use sorter transformation in joins?
From where we can start or use pmcmd?
What is difference between Mapplet and reusable transformation?
What is the use of code page?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
WHat all joins are there in Source Qualifier?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
What is aggregate cache in aggregator transformation?
How to list Top 10 salary, without using Rank Transmission?
What is an unconnected transformation?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
what is mean by flag 4 in update strategy t/r
Teradata 
