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 are the different ways to implement parallel processing in informatica?
What do you mean incremental aggregation?
what is mean by complex business rule ?
How we can create indexes after completing the load process?
What is workflow? What are the components of workflow manager?
What is main use of mapplet?
How can a transformation be made reusable?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain the shared cache and re-cache?
Define sessions in informatica etl?
What is primary and backup node?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Write the prerequisite tasks to achieve the session partition?
What is parallel processing in informatica?
What is Index Caches size?