How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
Answer Posted / shar
ok lets us say after getting result like
a,8000
b,9000
c,9999
acc to nandhini using dummy key would give me
a,8000,1
b,9000,1
c,9999,1
then use rem duplicate stage then we get 9999 as output after we assign retain duplicates=last for dummykey col.
what if
i have diff data and got output like below after aggreagation
a,9000
b,18000
c,10000
now what...?
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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...
What is difference between join, merge and lookup stage?
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
which r the connectors used in san?
Difference between data warehousing and olap?
What are the main differences you have observed between 7.x and 8.x version of datastage?
State the difference between an operational datastage and a data warehouse?
What are the partitioning techniques available in link partitioner?
how can we create rank using datastage?what is the meaning of rank?
Nls stands for what in datastage?
What are the important features of datastage?
table actions available in oracle connector?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How do you run datastage job from the command line?