how to get the first row without using rank t/r?
- 7 Answers
- 10509 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 a joiner transformation and why it is an active one?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Sequence generator, when you move from develoment to production how will you reset
Define joiner transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Mention some types of transformation?
is it possible to index the data in cache of lkp transformation ?
What are the advantages of using informatica as an etl tool over teradata?
What are mapplets? How is it different from a Reusable Transformation?
How might one distinguish in the case of mapping is right or not without associating session?
Explain what are the different types of transformation available in informatica.
Explian the Process of deployment groups in informatica
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is the Process to creating lookup transformation in informatica
