Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8534 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
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What do you understand by the term ‘transformation’?
What is the difference between round-robin partitioning and hash partitioning?
Difference between flat files and relational sources?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what is the main role of FI on business
what is an ETL or ETT? And what are the different types?
What is Data Vault???
Give the benefits of data integration suite?
how would u estimate the size of Aggregator transform data and index cache?
Compare etl & elt?
What is lookup table in etl testing?
What is tracing level?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what is the difference between cardinality and Nullability?
