how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 22013 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / punyaslok
(select * from emp)-(select rownum,emp.* from emp order by
mod(rownum,2);
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Global and Local shortcuts. Advantages.
What is confirmed fact in dataware housing?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the tuning techniques you applied during your last project
What is informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Write the prerequisite tasks to achieve the session partition?
What is event and what are the tasks related to it?
Explain the informatica workflow?
What if the source is a flat-file?
What are the different components of powercenter?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Under what conditions selecting sorted input in aggregator will still not boost session performance?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Define the various join types of joiner transformation?
