Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7937 Views
- I also Faced
- E-Mail Answers
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 do u convert the columns to rows in datastage?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
What is active and passive stage?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
How do u call shellscript/Batch file from DS?
How can one find bugs in job sequence?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
which cache supports connected & un connected Lookup
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
how can we do null handling in sequential files
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
What is ibm datastage flow designer?
Teradata 
