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
- 9163 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 do you understand by a term domain?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the need of an ETL tool?
Explain your project of banking domian.
where to store informatica rejected data?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is event and what are the tasks related to it?
What are session parameters ? How do you set them?
can we override a native sql query within informatica? How do we do it?
Why do we need informatica?
What is meant by active and passive transformation?
What is decode in static cache?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is degenerated dimension?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
