1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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


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

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

0 Answers  

Is the value of staging variable stored temporarily or permanently?

0 Answers  

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

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

1 Answers   TCS,

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  




What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

What are routines in datastage? Enlist various types of routines.

0 Answers  

What is the roundrobin collector?

0 Answers  

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

Main Function of the Staging area in DWH ?

2 Answers  

Explain usage analysis in datastage?

0 Answers  

What is job control?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories