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 |
How and where you used hash file?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
how can we create rank using datastage?what is the meaning of rank?
Why do you need stage variables?
What are the partition techniques available in your last project?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Hi Vijay here For Four CPU's how many nodes will required?
How can you find out whether datastage process is running or not in unix?
What are the main differences you have observed between 7.x and 8.x version of datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?