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
Give an idea of system variables.
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
what is the use of materialized view?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What a datastage macro?
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)
What is a ds designer?
What is the flow of loading data into fact & dimensional tables?
How do you register plug-ins?
Define orabulk and bcp stages?
Differentiate between hash file and sequential file?
On which Dimension Table you implemented SCD Type in your Project
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise