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 / guest
In the sql override, add a column for rownum which
generates the sequence numbers. Pass them into a filter
transformation to filter the records between 500 and 600.
And do the required aggregation through Aggregator
Transformation.
Through SQL :
select avg(sal) from (select id,name,sal,rownum r from
table_name )
where r between 500 and 600;
Hope this works..... if not please let me know
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
Separate from an archive server and a powerhouse?
What does reusable transformation mean?
How we can use union transformation?
What are mapplets?
Explain scd type 3 through mapping.
What is substr in informatica?
Global and Local shortcuts. Advantages.
What are some examples of informatica etl programs?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is aggregator transformation in informatica?
what is informatica metadata?
What is an active transformation?
What is the use of code page?
Can informatica load heterogeneous targets from heterogeneous sources?
