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

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,

1)Source file contains one record, I want 100 records in target file.

3 Answers  

How To find the location of APT_confid file

2 Answers   CTS,

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  




In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

0 Answers  

What is use Array size in datastage

0 Answers  

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

What is lookup table?

5 Answers  

Why we need datasets ratherthan sequential files?

5 Answers  

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

how will u design file watch jobs?

2 Answers  

For more Data Stage Interview Questions Click Here
Categories