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
- 9047 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain connectivity between datastage with datasources?
table actions available in oracle connector?
What is the difference between operational data stage (ods) and data warehouse?
Describe the main features of datastage?
How many types of hash files are there?
Define oconv () and iconv () functions in datastage?
What is difference between join, merge and lookup stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How you Implemented SCD Type 1 & Type 2 in your project?
Why fact table is in normal form?
What are the job parameters?
What is the purpose of pivot stage and types of containers in datastage
How to manage date conversion in Datastage?
What is the difference between passive stage and active stage?
