we hava more than 1000 records. i have to select first 5
record, last 5 record and 5 records from middle of the source.
how can i do in oracle as well as in informetica??
Answer Posted / akash
For implementation through Oracle:
Sort ASC/DESC on rowid in a sub-query and take first 5 rows
of this query in main query.
For implementation through informatica:
1. Use Rank Transformation.
2. Use Sorter Transformation.
The above are for first or last 5 records. Middle 5 records
are not included here.
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Can we create Hierarchies in generic datasources?
What is tracing level? How many types of transformations supported by sorted input?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
what is the difference between cubes and package in cognos
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What are dimensions?
What is meant by incremental load?
Explain do we need an etl tool?
What is partitioning? Explain different types of partitioning?
Define slowly changing dimensions (SCD)?
How to delete data which is not in source table?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?