1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

I have the following columns in the EMP table

Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981)

Desing a job such that the output contains the following

empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

Question Posted / alekhya


I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let ..

Answer / datastage4you

For getting current age, simply do the calculation in transformer, or in SQL itself


http://goo.gl/atN4AT
www.datagenx.net

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What are the various kinds of the hash file?

0 Answers  

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

options available in sequence job to run,validate?

0 Answers   CTS,




if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

How you can fix the truncated data error in datastage?

0 Answers  

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

how to sort two columns in single job in datastage.

1 Answers   TCS,

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  

4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail

1 Answers  

For more Data Stage Interview Questions Click Here
Categories