In several processing stages, we can choose or set the sort criteria (i.e. an link or “in-stage” sort). When you do that, one of those tiny “Sort” icons show …
You can practice the above questions and along with a few more by watching the below video: Previous Article: DataStage Interview Questions-4
The .odbc.ini file gives information about connecting to the database (wire protocol drivers) or the database client (non-wire protocol drivers). If your system uses a mix of drivers, your …
This is one of the most asked DataStage scenario based interview questions. I will solve this problem by taking some sample data. Input file: Sno,name,salary,rank 1,Naveen,10000,2 2,Joe,20000,2 3,David,30000,1 4,Richard,30000,2 …
This question can be answered easily in SQL in the following ways. Finding the nth highest salary in Oracle using rownum: Find nth highest salary in Oracle using RANK(): …
You can practice the above questions and along with a few more by watching the below video: Next Article: DataStage Interview Questions-2
You can practice the above questions and along with a few more by watching the below video: Previous : DataStage Interview Questions-1 Next : DataStage Interview …
Input file: Sno,name,salary,rank 1,Naveen,10000,2 2,Joe,20000,2 3,David,30000,1 4,Richard,30000,2 5,Obs,30000,1 1,Naveen,10000,2 1,Naveen,10000,2 3,David,30000,1 Output file: 1,Naveen,10000,2 1,Naveen,10000,2 3,David,30000,1 The final job design would be: First sequential file stage used to read …