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
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Define joiner transformation?
What are the data movement modes in informatica?
What if the source is a flat-file?
What is rank transformation in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the function of look up transformation?
How many ways are there to do 'remove duplicate records in informatica'?
What are the types of caches in lookup? Explain them.
What do you mean incremental aggregation?
Do you find any difficulty while working with flat files as source and target?
Explain the different kinds of facts.
What is meant by LDAP users?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?