i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i

i have a scenario with i/p as ID,salary with values 1,1000
2,2000 and 3,4000 i need an extra column in the o/p named
amount with values 2000,4000 and NULL. how can i get it?

Question Posted / dstyro

2 Answers
9182 Views
L&T, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra colum..

Answer / snr

Using TRS Satge with this logic

If ID=left(salary,1) then Salary*2 else 'Null'

Is This Answer Correct ?

12 Yes

1 No

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra colum..

Answer / rahul baheti

Input - Transfer - Output
In Transfer, apply the order by desc on ID and define two stage variable (SVC1, SVC2) put the if condition in stage variable against SVC1 (If SVC1 = NULL then setnull() else SVC1 = SVC2) and in SVC2, assian the sal.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More Data Stage Interview Questions

What are the unit test cases you used in your project?

1 Answers CSC, HY,

What is the difference between orabulk and bcp stages?

0 Answers

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers UHG,

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers Wipro,

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers Cap Gemini,

How complex jobs are implemented in datstage to improve performance?

0 Answers

How to find value from a column in a dataset?

0 Answers TIAA CREF,

What are the difference types of stages?

0 Answers

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers Wipro,

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers TCS,

what is meta data? Explain? Where it is used?

9 Answers

For more Data Stage Interview Questions Click Here