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
flat filevalidation in informatica
what is a worklet?
What are the etl testing operations includes?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What is etl tool in hadoop?
What is tracing level?
how many maximum session supports to multiload in teradata ??
What is full load & incremental or refresh load?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What are the ETL Testing Operations?
Explain the use lookup tables and Aggregate tables?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What is tracing level and what are the types?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
What is virtual Data Warehousing?