How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 13245 Views
- TetraSoft, I also Faced
- E-Mail Answers
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 the difference is between a database, a data warehouse and a data mart?
Explain the different dimensions.
Is it possible to revert a global repository to local one and why?
difference between repository database and repository service?
What is domain and gateway node?
Can we override a native sql query within informatica?
Enlist the differences between database and data warehouse.
How do we call shell scripts from informatica?
Different sorts of metadata that stores in the storage facility?
What do you understand by a term domain?
What are the different versions of informatica?
Mention some types of transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
When do you use sql override in a lookup transformation?
Differentiate between reusable transformation and mapplet.
