how to get the first row without using rank t/r?
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 intricate mapping?
Please let me know how to make Data masking in informatica..
How can you increase the performance in joiner transformation?
What is Cognos script editor?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the function of look up transformation?
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)
What is joiner change?
Explain what are the different types of transformation available in informatica.
What is complex mapping?
generate date / time dimension in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the components of the workflow manager?
What is the difference between informatica 7.0 and 8.0?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?