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
- 2137 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 flow of loading data into fact & dimensional tables?
Why we use surrogate key?
If you want to use the same piece of code in different jobs, how will you achieve it?
Differentiate between hash file and sequential file?
How many types of hash files are there?
How to manage date conversion in Datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
How you can fix the truncated data error in datastage?
What are some prerequisites for datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the functionalities of link partitioner and link collector?
What is the differentiate between data file and descriptor file?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is a ds designer?
