Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12412 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 domain and gateway node?
Is it possible to create multiple domains on a single Informatica server?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Define sessions in informatica etl?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain constraint based loading in informatica
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is a code page?
What are the different transaction levels available in transaction control transformation?
whats the logic to load the lower level of granularity of data to fact table.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the main features of Oracle 8i with context to datawarehouse?
Different circumstance which drives informatica server to expel records?
In which transformation you cannot drag ports into it?
Explain the types of lookup transformation?
