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
2983 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 find maximum salary by using Remove duplicate stage?

5 Answers IBM,

Explain datastage architecture?

0 Answers

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers EDS,

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers SLK Software,

how to delete one row in target dataset

0 Answers Satyam,

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers

How do you remove duplicate values in datastage?

0 Answers

what is initial load and incremental load

3 Answers ADP,

What is a datastage job?

0 Answers

How we can convert rows to columns in datastage?

4 Answers IBM,

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

1 Answers

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers HCL,

For more Data Stage Interview Questions Click Here