Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

i want for the 3rd max sal using for the any stage but max
sal is based on the deptno ?
any body know this ans pls send this mail siva3me@gmail.com

Question Posted / siva3me

Answers were Sorted based on User's Feedback



i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body ..

Answer / subhash

Src ---> Tfm ---> Tgt
in the TRANSFORMER Stage.

Do the HASH partitioning the incoming data and 'Perform
Sort' on DEPTNO ASC order and SAL DESC order.

and use 2 STAGE VARIABLES sv1=0 & sv2=0.

sv2 ===> If sv1=DEPTNO Then sv2+1 Else 1
sv1 = DEPTNO

And Put the below Link contraint:
sv2=3


Then u will get 3rd highest SAL from each DEPT.

Is This Answer Correct ?    5 Yes 0 No

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body ..

Answer / vinod

SIMPLE ONE IS.

USE THE TRANSFORMER STAGE.

BEFORE LOADING THE DATA IN TO TRANSFORMER STAGE THE DATA
MUST IN SORTED ORDER OF SAL AS DES AND DEPT AS ASC.

IN TRANSFORMER I AM GOING TO USE THE STAGE VARIABLES.

STR IF DEPT=STR1 THEN STR+1 ELSE 1

STR1 DEPT

THEN USE THE FILTER IN THAT PLACE CONDITION STR=3

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More Data Stage Interview Questions

What is "fatal error/rdbms code 3996" error?

0 Answers  

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

Differentiate between validated and Compiled in the Datastage?

0 Answers  

How do you import and export data into datastage?

0 Answers  

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?

3 Answers   TCS,

Unix command to view the data in a dataset

2 Answers   IBM,

Explain ibm infosphere information server and highlight its main features?

0 Answers  

how to delete one row in target dataset

0 Answers   Satyam,

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  

For more Data Stage Interview Questions Click Here
Categories