Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like

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

Question Posted / mahendersagar

1 Answers
2980 Views
I also Faced
E-Mail Answers

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a..

Answer / 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

More Data Stage Interview Questions

how to add a new records into source?

0 Answers

how to get the unique records on multiple columns by using sequential file stage only

3 Answers

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers Wipro,

sed,awk,head

0 Answers CTS,

when u face critical situation in ur project, how to solve them?

1 Answers Toyota,

What are the areas of application?

0 Answers

What is RCP

5 Answers CGI, CTS,

how to find out number of records imported into source file?

1 Answers

Where do you see different stages in the designer?