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
- 9219 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
Describe an informatica powercenter?
In informatica workflow manager, how many repositories can be created?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to extract sap data using informatica?
What is meant by query override?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to do the error handling of if ur source is flatfiles?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Differentiate between reusable transformation and mapplet.
Make a note of the quantity vaults made in informatica?
What is data caches/ index caches?
What is an expression transformation?
Design a mapping to load a target table with the following values from the above source?
What is lookup transformation?
COM components can be used in Informatica
