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
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the use of hoursfromtime() function in transformer stage in datastage?
What is ds designer?
Is the value of staging variable stored temporarily or permanently?
How you Implemented SCD Type 1 & Type 2 in your project?
Describe link sort?
What are the partitioning techniques available in link partitioner?
What is the purpose of pivot stage and types of containers in datastage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Define Routines and their types?
How many areas for files does datastage have?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance