Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 can we run same job in 1 day 2 times

7 Answers   IBM,

Define repository tables in datastage?

0 Answers  

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

What are sequencers?

0 Answers  

What is a delta record? How you will read it?

0 Answers   EDS,

What is a ds designer?

0 Answers  

what is ds administrator used for?

0 Answers  

How did you reconcile source with target?

3 Answers   HP,

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,

Describe the architecture of datastage?

0 Answers  

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories