Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 15012 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answer Posted / suresh
cant we write a subquery?
delete from table emp where exists (select * from emp where rownum=1 or 2 or 3);
count(empno) --> has to be stored in a variable port and delete the last three rows of the target table.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is the Default Source Option For Update Strategy Transformation?
What are the performance considerations when working with aggregator transformation?
Can u generate reports in Informatica?
Explain the types of lookup transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
what is SDLC way of code development?
Which development components of informatica have the highest usage?
How to delete duplicate row using informatica?
tell me the rules and responsblites in our project(my project is development)
Explain the informatica workflow?
How can we use mapping variables in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
how tokens will generate?
server hot-ws270 is connect to Repository B. What does it mean?
What are the tasks that source qualifier perform?
