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
Please let me know how to make Data masking in informatica..
Write the prerequisite tasks to achieve the session partition?
Define mapping and session?
What is persistent lookup cache?
Can informatica load heterogeneous targets from heterogeneous sources?
what is unit testing?tell me proceedure
What is the status code in stored procedure transformation?
What do you mean by channel change?
What are the reusable transformations?
What is dimensional table? Explain the different dimensions.
How do you manage the Parameter files while migrating your data from one environment to another environment?
How do you take back up of repository?
Why sorter is an active transformation?
What are mapplets? How is it different from a Reusable Transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C