how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / siva reddy
display odd records
select * from emp where (rowid,1) in ( select
rowid,mod(rownum,2) from emp)
display even records
select * from emp where (rowid,0) in ( select
rowid,mod(rownum,2) from emp)
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is meant by lookup transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is data transformation manager process?
Differentiate between source qualifier and filter transformation?
can we override a native sql query within informatica? How do we do it?
I have a flat file, want to reverse the contents of the flat file
Explain the shared cache and re-cache?
Describe data concatenation?
What is option by which we can run all the sessions in a batch simultaneously?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What do you mean by filter transformation?
Enlist few areas or real-time situations where informatica is required.