Answer Posted / shar
sed 's/' '//g ' sample
Or
Other way:(just in case)
In Transformer we can use function : CompactWhiteSpace(%string%)
Through which we can remove spaces.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are stage variables and constants?
Define Job control?
On which Dimension Table you implemented SCD Type in your Project
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Explain how a source file is populated?
What are the partitioning techniques available in link partitioner?
Triggers,VIEW,Procedures
What is difference between join, merge and lookup stage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Differentiate between datastage and datastage tx?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is orabulk stage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?