Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 8590 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
How rejected rows are managed in datastage?
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 are the prerequisites for join stage
What are the different layers in the information server architecture?
how do you pass parameters in a script?
What is the version control how can i apply this in DataStage can any one tell me the anser
what is materialized view used datastage?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
Why do we use link partitioner and link collector in datastage?
What is exact difference between Parallel Jobs and server Jobs..
Name the command line functions to import and export the DS jobs?
Teradata 
