Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 9169 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is a merge?
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?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
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
Explain the ChangeApply stage?
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
What are the steps required to kill the job in Datastage?
How to initialize environment variables?
Teradata 
