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
- 8667 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 are cubes and olap cubes?
what is the use of structures?how many nodes can u create in a structure?
how would u estimate the size of Lookup transform data and index cache?
what is Forward,Reverse and Re_engineering?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
List few etl bugs?
Difference between flat files and relational sources?
What is the difference between project backlog and product backlog?
What is virtual Data Warehousing?
Explain about the data integration suite features?
what is the difference steps for data modeling?
What are the three tiers in etl?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What is fact? What are the types of facts?
what is the difference between cardinality and Nullability?
