Interested to Buy Any Domain ? << Click Here >> for more details...
i want anser this question empno,ename,sal 12,mmm_ww,200
13,nnn_xx,300 14,bbb_qq,400 which stages are take which
types of logicks are doing pls help me i don't need "_"ex
nnnxx this type i want
- 3 Answers
- 8041 Views
- I also Faced
- E-Mail Answers
Answer Posted / roshan nayak
To achieve this use "Convert" function.
ex - Convert('+-_()?','',NullToEmpty(Input_link))
this will convert "_" or any of the specify special
char-rector with empty string.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Explain connectivity between datastage with datasources?
What is difference between join, merge and lookup stage?
How do u convert the columns to rows in datastage?
Have you used Unstructured data?
What is the process of killing a job in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Differentiate between datastage and datastage tx?
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 are the main features of datastage?
What are routines in datastage? Enlist various types of routines.
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Can you explain engine tier in information server?
What all the types of jobs you developed?
What are the partitioning techniques available in link partitioner?
What is process model?
