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



i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages ..

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

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages ..

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

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages ..

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

Post New Answer

More Data Stage Interview Questions

which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,


How you can fix the truncated data error in datastage?

0 Answers  


What are the types of hashed files in data stage

0 Answers  


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

0 Answers   IBM,


on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,






how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,


table actions available in oracle connector?

0 Answers   CTS,


What are the functionalities of link collector?

0 Answers  


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,

3 Answers   TCS,


why we use hash file for lookup?

5 Answers  


What are the prerequisites for join stage

2 Answers  


Enlist various types of routines in datastage.

0 Answers  


Categories