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
- 7605 Views
- I also Faced
- E-Mail Answers
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 an ETL or ETT? And what are the different types?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
Explain do we need an etl tool?
When do we analyze the tables?
What are the key benefits of ETL Testing?
How to delete data which is not in source table?
What are cubes and olap cubes?
Explain and compare etl & manual development?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Identifying the bottlenecks in various components of Informatica and resolving them.
Can there be sub steps of etl steps?
Define Dynamic push down optmization?
What are your responsibilities as an etl tester?
what is the meaning of upgradation of Repository?
what is the main role of FI on business
