Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 4 Answers
- 8495 Views
- I also Faced
- E-Mail Answers
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 are the modules in Power Mart?
Explain about the data integration suite features?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
what is an ETL or ETT? And what are the different types?
explain the methodology of Data Warehousing?(Polaries)
flat filevalidation in informatica
Two default user groups created in the repository are____and_____.
what happens if the info.server doesn't find the session parameter in the parameter file?
what is the difference between cardinality and Nullability?
what is a worklet?
What is fact? What are the types of facts?
What is abap? What are idocs?
Mention few test cases and explain them?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Difference between flat files and relational sources?
