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
What is full load & incremental or refresh load?
What is etl process? How many steps etl contains?
Explain what is etl process? How many steps etl contains explain with example?
Identifying the bottlenecks in various components of Informatica and resolving them.
how to connect to a flatfile through ftp in informatica
Explain about round-robi?
Explain about power designer data modeling software?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
how do u really know that paging to disk is happening while u are using a lookup transform?
What is a materialized view log?
What is a mapping, session, worklet, workflow, mapplet?
What is data cleaning?
What are dimensions?
how do u extract data from different data sources explain with an example?