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 |
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
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
Can you implement SCD2 using join, transformer and funnel stage?
What is diff between Junk dimensions and conform dimension?
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
If you want to use a same piece of code in different jobs, how will you achieve this?
how to design the change capture stage in(data stage parallel jobs) type 2
What is the purpose of pivot stage and types of containers in datastage
how do u reduce warnings
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..
What is quality stage?
Which algorithm you used for your hashfile?