Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 6851 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
how can find maximum salary by using Remove duplicate stage?
What is the difference between Datastage 7.5 and 7.0?
what is the best stage in datastage parller jobs to use full out join and why
1)How to Duplicate Records Delete in Sequential file?
What is apt_config in datastage?
How to display all the duplicate records from the oracle Table?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
where we use column generator stage in real time scenario?
Can you explain tagbatch restructure operator?
how to design the change capture stage in(data stage parallel jobs) type 2
Teradata 
