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
- 8679 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
how to abort the job its matain duplicates?
How to reverse the string using SQL?
Notification Activity
Have you have ever worked in unix environment and why it is useful in datastage?
Define ds designer?
how to export or import the jobs in .ISX file
What is the difference between informatica and datastage?
What are the benefits of datastage?
How will you move hashed file from one location to another location?
Is possible to create skid in dim,fact tables?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What a datastage macro?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Explain connectivity between datastage with datasources?
