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

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,


30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  


Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,


What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,


6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,






If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  


how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,


What is the purpose of pivot stage and types of containers in datastage

0 Answers  


how do u reduce warnings

1 Answers   CGI,


iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,


What is quality stage?

0 Answers  


Which algorithm you used for your hashfile?

0 Answers  


Categories