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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / venugopal
In the transformer stage use field function to remove "-"
and get the proper o/p... it will help u...
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / subhash
in your table any stage can be Executed this is like one table
here no logic and nnn_xx this like ename "they are specify ename like this only "
Is This Answer Correct ? | 0 Yes | 2 No |
which is the most complex job in your career? Please tell me answer?
How you can fix the truncated data error in datastage?
What are the types of hashed files in data stage
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
on how many columns we can perform aggregation in the Aggregator stage?
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
table actions available in oracle connector?
What are the functionalities of link collector?
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
why we use hash file for lookup?
What are the prerequisites for join stage
Enlist various types of routines in datastage.