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
2933 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 do null handling in sequential files?

3 Answers Reliance,

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers HCL,

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers IBM,

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers TIAA CREF,

what is meta data? Explain? Where it is used?

9 Answers

What's the Main Function of the Staging area in DWH

3 Answers Oracle,

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers IBM,

describe the Steps to confiure a Qlogic switch

0 Answers IBM,

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers Amdocs,

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers

DataStage Scenario based Interview Questions

1 Answers

For more Data Stage Interview Questions Click Here