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
- 2820 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
Can you explain how could anyone drop the index before loading the data in target in datastage?
Does datastage support slowly changing dimensions ?
How do you run datastage job from the command line?
What are routines in datastage? Enlist various types of routines.
What are the functionalities of link collector?
How do u convert the columns to rows in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the process of killing a job in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How do you generate sequence number in datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the areas of application?
Describe the main features of datastage?
