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
- 8715 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 |
What modeling tool do you use?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
Why we use parameters instead of hard code in datastage.
How to manage date conversion in Datastage?
how many dimentions and fact tables used in your project and what are names of it?
Describe link sort?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
whats difference between ls -ltr and ls -lrt?
How to reverse the string using SQL?
How you Implemented SCD Type 1 & Type 2 in your project?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Teradata 
