Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / madhu_123

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

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

0 Answers  

What are stage variables and constants?

0 Answers  

How many types of sorting methods are available in datastage?

0 Answers  

What is the difference between an operational datastage and a data warehouse?

0 Answers  

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

what is initial load and incremental load

3 Answers   ADP,

What are the main features of datastage?

0 Answers  

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

How do you load dimension data and fact data? Which is first

2 Answers  

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

For more Data Stage Interview Questions Click Here
Categories