Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 22059 Views
- I also Faced
- E-Mail Answers
Answer Posted / rag
We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,
like select col1,col2,rownum
from tab1
where rownum=3
| Is This Answer Correct ? | 1 Yes | 21 No |
Post New Answer View All Answers
How to use pmcmd utility command?
Is it possible to revert a global repository to local one and why?
What is confirmed fact in dataware housing?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is lookup transformation?
What are the different types of transformation available in informatica.
If informatica has its scheduler why using third party scheduler?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Write the different tools in the workflow manager?
How can we use batches?
What is a router transformation?
What are the tasks that source qualifier perform?
What is a dimensional model?
