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 mapplet in informatica?
Which version configuration tool used in ur project?
What are the main features of Oracle 8i with context to datawarehouse?
What is workflow? What are the components of the workflow manager?
Different qualification between a related rotate toward the sky and isolates look upward?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Please let me know how to make encryption and decryption with example?
What are session parameters ? How do you set them?
What are the informatica performance improvement tips
How do you take back up of repository?
How can we improve session performance in aggregator transformation?
Explain how to import oracle sequence into informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What is exclusive and normal mode for repository services?
How to differentiate between the active and passive transformations?