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
- 8788 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
how to connect to a flatfile through ftp in informatica
Explain what are the various etl tools in the market?
what is granularity in Data ware House?
What is the difference between project backlog and product backlog?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
SCD2 will work on only dimension tables as well as fact Table?
What are the three tiers in etl?
list and discuss two approaches for updation of target table in Informatica and how they are different.
explain the methodology of Data Warehousing?(Polaries)
How many types of transformations supported by sorted input?
what do u do when DB time takes more?in sap bi
how do u identify the changed records in operational data?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is cube grouping?
how many maximum session supports to multiload in teradata ??
