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
What is blocking transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Quickly characterize reusable change?
have u done any performance tuning? how u ll do?
Which are the different editions of informatica powercenter that are available?
What are the modules in Power Center
how to load rows into fact table in data warehouse
where to store informatica rejected data?
What do you understand by a term domain?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to delete duplicate row using informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the meaning of up gradation of repository?
What is different between the data warehouse and data mart?