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
- 6715 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 |
how to sort two columns in single job in datastage.
What are the job parameters?
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
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is RCP
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
What is size of a transaction and an array means in a datastage?
How can we do null handling in sequential files?
why we use parameters instead of hard code in datastage
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
What are the functionalities of link partitioner and link collector?
Teradata 
