Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
My source is oracle(eno,ename,sal,commision,...), my
requirement is like this,
if there is a null values in commission col i want to keep
it as null,and for the remaining first two characters of
the value in my target.
Plz help me
- 1 Answers
- 2923 Views
- I also Faced
- E-Mail Answers
Answer Posted / anburadh
src--->TFM--->Tgt
in TFM for Commission column derivation,assign
If commission = NULL then NULL else LEFT(commision,1,2)
Hope this will work....correct me if i am wrong.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to abort the job its matain duplicates?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the difference between operational data stage (ods) and data warehouse?
Define Data Stage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the different common services in datastage?
What is the process of killing a job in datastage?
What is a folder? Difference types of stages?
Difference between sequential file and data set?
What is the difference between server job and parallel jobs?
How you can fix the truncated data error in datastage?
What is the difference between validated and compiled in the datastage?
What are sequencers?
why do u need the IOS upgradation in a FC switch
What are the important features of datastage?
