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
- 9027 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
What does cheating measurement mean?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
what is INFORMATICA TESTING process
Under what condition selecting sorted input in aggregator may fail the session?
what is index?how it can work in informatica
What does refresh system mean, and what are its distinctive choice?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
explain abt ur project architecture?
Different circumstance which drives informatica server to expel records?
Differentiate between sessions and batches?
What happens when a session fails and you click on recover?
Partition, what happens if the specified key range is shorter and longer
Define pmcmd command?
How are the sources and targets definitions imported in informatica designer?
How to implement security measures using repository manager?
