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
what is the difference between cardinality and Nullability?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What is the difference between project backlog and product backlog?
can cubes contain measures ?
how do use session mapping parameters ?(in which transformation)
Explain do we need an etl tool? When do we go for the tools in the market?
what do u do when DB time takes more?in sap bi
How etl testing is different from database testing?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Define Dynamic push down optmization?
Explain about the data integration suite features?
what is granularity in Data ware House?
What is abap? What are idocs?
What do you understand by the term ‘transformation’?