Interested to Buy Any Domain ? << Click Here >> for more details...
Hi frnds, my scenario is like i'm having a record
1234"1323£3434%343434^23232!1212$23232
in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
- 2 Answers
- 16889 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajendhar reddy kuthuru
we can use convert function to remove special characters or replace a string
convert('$%^@"!',"",string)-stage var1
it will replace all special characters with a single space
compactwhitespace(stagevar1)
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / srinivas
Please use below function.
convert('!@#$%^&*','',string)
No need of the give space in between codes
Only one step to solve this.
| Is This Answer Correct ? | 11 Yes | 0 No |
Can we use Round Robin for aggregator?is there any benefit underlying?
What are sequencers?
why we use parameters instead of hard code in datastage
How many types of sorting methods are available in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
What are the features of datastage flow designer?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
what are fact tables and dimension tables? give example assuming one table.
What is process model?
What is a datastage job?
How do you register plug-ins?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
Teradata 
