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
- 2974 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 are the repository tables in datastage?
Have you used Unstructured data?
AGGREGATOR default datatype
What is a folder? Difference types of stages?
How a source file is populated?
Give an idea of system variables.
What is ibm datastage?
Is it possible to query a hash file?
sed,awk,head
What is orabulk stage?
Explain datastage architecture?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How can we improve performance of data stage jobs?
Define Job control?
What is the difference between datastage and informatica?
