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
- 2156 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 convert RGB Value to Hexadecimal values 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?
What are the benefits of datastage?
What are iconv and oconv?
what is the use of skid in reporting?
What is the difference between passive stage and active stage?
What is "fatal error/rdbms code 3996" error?
Describe the main features of datastage?
What is the difference between in process and inter process?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How to clean the datastage repository?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How to read the length of word in unix?
State the difference between an operational datastage and a data warehouse?
