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
Differentiate between source qualifier and filter transformation?
What are the various types of transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what is size of u r database?
What is the scenario which compels informatica server to reject files?
difference between informatica 8.1.1 and 8.6
Explain the types of lookup transformation?
Describe an informatica powercenter?
Enlist some properties of sessions.
In informatica workflow manager, how many repositories can be created?
How do you update the records with or without using update strategy?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
how to create user defined function (udf) in informatica
Difference between Data and Index Caches?
What is primary and backup node?