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


Please Help Members By Posting Answers For Below Questions

difference between informatica 8.1.1 and 8.6

3246


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1642


What are the components of Informatica? And what is the purpose of each?

624


What is the benefit of session partitioning?

601


How do you update the records with or without using update strategy?

666






pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


What is workflow? What are the components of the workflow manager?

646


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1535


Write the advantages of partitioning a session?

754


can u any challenge your project?

1612


without table how to come first record only in oracle?

1861


in reporting we add some new objects,how we get the count of the newly added objects to the report

1755


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2142


Define pmcmd command?

628


How might one distinguish in the case of mapping is right or not without associating session?

644