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?
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
What is the difference between operational data stage (ods) and data warehouse?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
sed,awk,head
Distinguish between informatica & datastage. Which one would you choose and why?
What are the different options associated with dsjob command?
Can we use target hash file as a lookup ?
Why we use surrogate key?
Explain connectivity between datastage with datasources?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the difference between the local container and shared container?
how to abort the job its matain duplicates?
What is the roundrobin collector?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How do you run datastage job from the command line?
Can you explain kafka connector?