Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12652 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / balakrishna
select empno,name,deptno,loc from emp where rownum=1
and
first using sorter select asc,create expression t/r using the variable v_count=v_count+1,o_count=v_count after using the filter t/r to write condition o_count=1 connect filter t/r to target
and
source--->sq--->seq--->exp--->filter--->target
and
select * from emp where rownum=1minusselect * from emp where rownum=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the databases that informatica can connect to windows?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
server hot-ws270 is connect to Repository B. What does it mean?
What are the different components of powercenter?
Explain in detail about scd type 1 through mapping.
What is joiner change?
Enlist the tasks for which source qualifier transformation is used.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
wf dont have integration severances how you can run?
Difference between Data and Index Caches?
What is a standalone command task?
Which version configuration tool used in ur project?
What is Session and Batches?
What is the use of target designer?
