how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
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
Briefly describe lookup transformation?
How can informatica be used for an organization?
What is target load order?
Can we create a Integration service without a Repository service and vice versa?
What are the modules in Power Center
How many types of sessions are there in informatica.please explain them?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain the mapping variable usage example in informatica
How to join three sources using joiner? Explain though mapping flow.
Why sorter is an active transformation?
What are the types of lookup transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is mapplet in informatica?
What is a connected transformation?