Interested to Buy Any Domain ? << Click Here >> for more details...
replace multiple spaces with single space.
- 3 Answers
- 6627 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 one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
what is parameter file?
what is bitmap index? did u use it?and how to use it in informatica
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
what is the diff b/w union and joiner and lookup?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
What are partitions in informatica and which one is used for better performance?
what is data driven?
how to calculate the optimum cache size in aggregator transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How will you update the first four rows and insert next four rows in a mapping?
What are the different threads in DTM process?
Teradata 
