How to delete first 3 rows & last 3 rows in target table in
informatica
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
difference between informatica 8.1.1 and 8.6
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the components of Informatica? And what is the purpose of each?
What is the benefit of session partitioning?
How do you update the records with or without using update strategy?
pmscmd startworkflow -sv
What is workflow? What are the components of the workflow manager?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Write the advantages of partitioning a session?
can u any challenge your project?
without table how to come first record only in oracle?
in reporting we add some new objects,how we get the count of the newly added objects to the report
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Define pmcmd command?
How might one distinguish in the case of mapping is right or not without associating session?