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
how to load the data to fact table?
Do we need an etl tool?
what are the data modeling tools you have used?(polaris)
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
how do u really know that paging to disk is happening while u are using a lookup transform?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What are the steps involved in etl process?
what are the production issues in datastage?
What is partitioning? Explain about round-robin, hash partitioning.
what is session partitioning?
what is the main role of FI on business
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
what is pmrep command?
how do u extract data from different data sources explain with an example?
What do you understand by active and passive transformations?