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

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

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

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1 Answers  

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

what is the difference between datasatge and datastage TX?

6 Answers  

Difference between in process and inter process?

1 Answers  

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

What is ibm datastage?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories