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 / babu

Hi Guys,
small change is there in above solution

i.e:: GRP2:sno<=(cno/2)+2 AND sno>=(cno/2)-2




Cheers,
Babu Rao

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to load the data to fact table?

2153


Do we need an etl tool?

557


what are the data modeling tools you have used?(polaris)

1547


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1356


how do u really know that paging to disk is happening while u are using a lookup transform?

2042






HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1654


What are the steps involved in etl process?

517


what are the production issues in datastage?

9738


What is partitioning? Explain about round-robin, hash partitioning.

549


what is session partitioning?

1459


what is the main role of FI on business

1627


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2093


what is pmrep command?

1956


how do u extract data from different data sources explain with an example?

1774


What do you understand by active and passive transformations?

550