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
2909 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 can we create tables in datastage?

1 Answers

What is exact difference between Parallel Jobs and server Jobs..

8 Answers DELL, IBM,

why dataset ?

2 Answers

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers Reliance,

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

0 Answers CTS,

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers

difference between server shared container and parallel shared container

6 Answers CTS,

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

0 Answers

How can we improve the performance in datastage?

0 Answers

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers TCS,

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers

For more Data Stage Interview Questions Click Here