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

What are the different types of lookups in datastage?

0 Answers  

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

how to define satge variables in transformer stage

2 Answers  

What is the difference between orabulk and bcp stages?

0 Answers  

How to display errors in datastage?

1 Answers   TCS,




How to read the length of word in unix?

0 Answers   CTS,

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,

Describe stream connector?

0 Answers  

what is usage of datastage with materialized views

4 Answers   HP, TCS,

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

What is the use of datastage director?

0 Answers  

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories