Interested to Buy Any Domain ? << Click Here >> for more details...
how can i get 2nd highest salary in datastage?can u send me
,thanQ
2)if i had source has 2 records 1st record ie 1st column
contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to
get target as 2nd columns as 20,30,40 how can i?
- 3 Answers
- 23577 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / farzana kalluri
seq file--->sort(descending)stage--->surrogate key stage---
>target
sort tha data in descending order ,then it will shows from
highiest salary, after that keep surrogate key stage it
will automtaically generates the nos so that we can
identifiy the 2nd hieght salary .
| Is This Answer Correct ? | 9 Yes | 1 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.
What can we do with datastage director?
What is the difference between hashfile and sequential file?
What is ibm datastage?
What are the steps required to kill the job in Datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to read multiple files using a single datastage job if files have the same metadata?
Name the different types of Lookups in Datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the different plug-ins stages used in your projects?
What is datastage?
