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
- 2847 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 is the use of datastage designer?
What is aggtorec restructure operator?
What are datastage sequences?
What is job control?
Name the third party tools that can be used in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
What are the different types of lookups in datastage?
Difference between sequential file and data set?
Is it possible to query a hash file?
Define data aggregation?
What are some different alternative commands associated with "dsjob"?
How do you reject records in a transformer?
project Steps,hits, Project level HArd things,Solved methods?
Where the datastage stored his repository?
What is size of a transaction and an array means in a datastage?
