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
- 8666 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
Difference between flat files and relational sources?
What is data cleaning?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is tracing level?
Do we need an ETL tool? When do we go for the tools in the market?
Can we create Hierarchies in generic datasources?
what are the reports developed in sap bw project and what is the requirement for developing it?
How many types of transformations supported by sorted input?
What are the key benefits of ETL Testing?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Explain etl?
What do you understand by the term ‘transformation’?
Explain about the data integration suite features?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
how do u extract data from different data sources explain with an example?
