How can you find the 2nd Highest salary in a file department wise in abinitio?
Answer Posted / sridhar
when each group is having two 2nd higest values this logic
will not work.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between partitioning with key / hash and round robin?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What do you know about partition and also tell us about partition components in abinitio?
What do you mean by the term data warehousing? Is it different from data mining?
To which project that prefix will set is to private project or public project or both?how and where to set?
What information is provided by .dbc file extension for connecting to the database?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What are the primary keys and foreign keys?
Mention how can you connect eme to abinitio server?
What is a rollup component?
Why might the optimizer use a table scan when an index is available?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
Define ramp limit in ab initio?
Can you explain the performance and scalability of co> operating system?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?