Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12502 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 is rank transformation?
Do you find any difficulty while working with flat files as source and target?
How do you set a varible in incremental aggregation
Explain Dataware house architecture .how data flow from intial to end?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Clarify the utilization of aggregator cache record?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is Data Caches size?
What are the new features of informatica 9.x at the developer level?
What are the performance considerations when working with aggregator transformation?
What is informatica metadata and where is it stored?
where to store informatica rejected data? How to extract the informatica rejected data?
tell me about your project functionality
In informatics server which files are created during the session rums?
r u done any partitions in ur project?
