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
- 2317 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
What are the types of jobs we have in datastage?
In Datastage, how you can fix the truncated data error?
how to sort two columns in single job in datastage.
Define Job control?
On which interface you will be working as a developer?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the components of datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Differentiate between operational datastage (ods) and data warehouse?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are sequencers?
What are the features of datastage flow designer?
How do u convert the columns to rows in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
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
