how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / anjan
select rownum,empno,ename,sal from (select
rownum,empno,ename,sal from emp)
group by rownum,empno,ename,sal
having rownum in (1,3,5)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what is the -ve test case in your project.
What is informatica? Why do we need it?
I have a flat file, want to reverse the contents of the flat file
Explain the use of aggregator cache file?
Define update strategy?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Why update strategy and union transformations are active? Explain with examples.
What is the use of code page?
How do you take back up of repository?
Enlist few areas or real-time situations where informatica is required.
What are the different clients of powercenter?
What is a grid in Informatica?
Mention some types of transformation?
what is Active lock explain