adspace


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

have the sequence generator transformation in the mapping
whcih will give you the row numbers.

From there you can take watever rows you want. From 1 to
last or anything.

This wil help you.

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2114


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4203


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

1782


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

2073