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

How to create user defined environment varibale(parameter)?

1 Answers   TCS,

What are the prerequisites for join stage

2 Answers  

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

State the difference between an operational datastage and a data warehouse?

0 Answers  

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,




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

0 Answers  

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 Answers  

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

What is data partitioning?

0 Answers  

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

For more Data Stage Interview Questions Click Here
Categories