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
- 8650 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 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)
What is etl process. How many steps etl contains explain with example?
what is the use of structures?how many nodes can u create in a structure?
what is the use of server?
can cubes contain measures ?
Compare etl & elt?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is partitioning? Explain about round-robin, hash partitioning.
where is the cache (lookup, index) created and how can you see it.
list and discuss two approaches for updation of target table in Informatica and how they are different.
how do u extract data from different data sources explain with an example?
Do we need an etl tool?
How etl testing is different from database testing?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is grain of fact?
