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
- 2984 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
whom do you report?
What are the components of datastage?
Difference between server jobs & parallel jobs?
What is the sortmerge collector?
What is "fatal error/rdbms code 3996" error?
Differentiate between Join, Merge and Lookup stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
sed,awk,head
What is the difference between odbc and drs stage?
How to clean the datastage repository?
How to reverse the string using SQL?
What is staging variable?
What is difference between server jobs & parallel jobs?
