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

how will u design file watch jobs?

2 Answers  

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

Can you filter data in hashed file?

0 Answers  

what is hash file

2 Answers   CTS, IBM,

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,




What is the difference between the local container and shared container?

0 Answers  

What is the difference between Link collector and Funnel Stages?

1 Answers  

What are constraints and derivations?

0 Answers  

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

Define project in datastage?

0 Answers  

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

For more Data Stage Interview Questions Click Here
Categories