Interested to Buy Any Domain ? << Click Here >> for more details...
how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 25870 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
Select * from (select rownum as rno, emp.* from emp) where
rno in (1,3,5);
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How we can create indexes after completing the load process?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a node in Informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the mapping parameters and mapping variables?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the need for an etl tool?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to update source definition?
What is joiner transformation?
Explain the use of aggregator cache file?
How do you handle two sessions in Informatica
design of staging area?
