ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> Data Stage
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (751)
 Cognos interview questions  Cognos Interview Questions (842)
 Informatica interview questions  Informatica Interview Questions (1622)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (168)
 Data Stage interview questions  Data Stage Interview Questions (563)
 SAS interview questions  SAS Interview Questions (550)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (215)
Question
How to get max salary of an organization using data stage
stages...........

can any body help me plz.......
 Question Submitted By :: Data-Stage
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
firstly read the file into database or sequential file and
make sure the file has company as a column in this file and
give its output to aggregator and in aggregator give
group=company and column to calculate=sal and maximum value
for output column=maxsal and do mapping to the dataset and
you will get the required result.
 
Is This Answer Correct ?    14 Yes 4 No
Naga
 
Answer
# 2
Frist using Sortstage sort the records based on sal column
for desc order and Each record unqiely identify using
surogatekey after that filterstage filter the first record
based on sur column and drag and drop only in sal column
in the output.Then We get the Max sal
 
Is This Answer Correct ?    4 Yes 0 No
Guest
 
 
 
Answer
# 3
Hi Naga,
If we use Aggregator stage, it will give the max value from
different groups, as per your example, it will group by
company, then it will give the max sal from each group. but
how to max sal from all the groups, i mean the out put
should be only one value.

Ex:

COMPANY,SAL
A, 2000
B, 3000
C, 4000
A,5000
B,6000
C,7000
A,8000
B,9000
C,9999

if we do like you mention output will be like :
comp,maxsal
A,8000
B,9000
C,9999

But, the output should be only
C,9999

Plese let me if iam wrong.
 
Is This Answer Correct ?    4 Yes 0 No
Amjad
 
Answer
# 4
Create one dummy key and set the value as 1 for all input
columns and use remove duplicate stage. Here use this dummy
as key and use sorting, partitioning for dummy and company
columns & use sorting (descending) for salary column and in
properties tab, select duplicate to retain as last.
 
Is This Answer Correct ?    3 Yes 0 No
Nandhini
 
Answer
# 5
U can use Aggregator stage in Datastage 
Is This Answer Correct ?    0 Yes 3 No
Guest
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
how can you generate sequence number using only the sequential file stage? TIAA-CREF 3
what is the difference between datasatge and datastage TX?   6
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use IBM 4
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks Cap-Gemini 3
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks. AMDOC 1
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks. UHG 4
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?   3
Tell me Wt main advantage of Stage varibles? Project level hints? Hexaware 4
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC? TCS 1
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how? Hexaware 1
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com tcs 2
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it? L&T 3
 
For more Data Stage Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com