Interested to Buy Any Domain ? << Click Here >> for more details...
How to find from a source which has 10,000 records, find the
average between 500th to 600th record?
- 3 Answers
- 9327 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudhar
Your answer is correct for the flat files. But the RElation
query you have given won't give any records.
the Query should like this
select avg(sal) from
(select emp_id, sal, rownum rnum from (
select emp_id,sal from emp order by sal desc) )where rnum
between 500 and 600
Might be this Query can be simplified with Rank option in
Oracle.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the types of transformations?
What is dimensional table? Explain the different dimensions.
What is the use of code page?
What is data movement mode in Informatica and difference between them?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Define joiner transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is source qualifier transformation in informatica?
How to use procedural logic inside infromatica?
What is a difference between complete, stop and abort?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the use of an aggregator cache file?
What is repository manager?
What are the different clients of powercenter?
