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
- 2902 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 achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Can you implement SCD2 using join, transformer and funnel stage?
which r the connectors used in san?
client know skid info?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
root tree will find which is server job and which is parallel job?
How a source file is populated?
What is the flow of loading data into fact & dimensional tables?
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?
Describe the architecture of datastage?
What are the types of containers and how to create them?
Does datastage support slowly changing dimensions ?
What is oci?
EXPLAIN SCD
What is datastage?
