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
When do we analyze the tables?
How to increase performance without changing anything in mapping.( In prod)
Do we need an etl tool?
what is session partitioning?
What is etl tool in hadoop?
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
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
how many maximum session supports to multiload in teradata ??
What are dimensions?
What is fact? What are the types of facts?
What are the ETL Testing Operations?
what is granularity in Data ware House?
Can u access a repository created in previous version of Informatica?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What are snapshots?