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...


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



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 is active and passive stage?

0 Answers  


What is the difference between orabulk and bcp stages?

0 Answers  


i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,


What is process model?

0 Answers  


Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  


Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,


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,


Define orabulk and bcp stages?

0 Answers  


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,


What are the different options associated with dsjob command?

0 Answers  


table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  


Can you explain repository tables in datastage?

0 Answers  


Categories