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 |
Wat is isolation level and when do u use them?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
How did you reconcile source with target?
what is time dimension? and how to populate time demension
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
How do you remove duplicate values in datastage?
Where do the datastage jobs get stored?
What are the different layers in the information server architecture?
what r the sources u need to create the datastage?
Difference between server jobs & parallel jobs?