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
- 8634 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 |
how do u catch bad rows from OCI stage? And what CLI stands for?
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
how to sort two columns in single job in datastage.
how can i abort the job if i get more than 100 errors in job log?
What is the difference b/w Hash file and Lookup Fileset stages?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
why do u need the IOS upgradation in a FC switch
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
What are orabulk and bcp stages?
plz tell me some dimentional and fact table names in banking project?
what is the use of DSattchJob?DetachJob? where can we find it?
Teradata 
