Interested to Buy Any Domain ? << Click Here >> for more details...
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
If you want to use the same piece of code in different jobs, how will you achieve it?
How many Key we can define in remove duplicate stage?
Explain how a source file is populated?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
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 a quality stage in datastage tool?
sed,awk,head
What are the components of datastage?
Define Job control?
Triggers,VIEW,Procedures
Give an idea of system variables.
which r the connectors used in san?
How do you reject records in a transformer?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is the sortmerge collector?
