How to delete first 3 rows & last 3 rows in target table in
informatica
Answer Posted / civa
take seq trns and drag nextval port into exp trns and also
drag sq ports to exp
in exp delete from emp where nextval= 1 or 2 or 3 and
nextval=count(empno)-1 or count(empno)-2 or count(empno)-3
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is repository manager?
What are the steps involved in the migration from older version to newer version of Informatica Server?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is a predefined event?
In how many ways we can create ports?
explain one complex mapping with logic? sales project?
What are mapplets? How is it different from a Reusable Transformation?
What is enterprise data warehousing?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How can we use mapping variables in informatica?
What is workflow? What are the components of workflow manager?
What are the components of the workflow manager?
Why is sorter an active transformation?
What is union transformation?
What is the difference between stop and abort in informatica