Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 14748 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 happens when a session fails and you click on recover?
Explain lookup transformation source types in informatica
Difference between Target-based loading and constraint-based loading?
What all join we can perform in LOOKUP transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Different circumstance which drives informatica server to expel records?
How can we store previous session logs?
Where is metadata stored?
what is SDLC way of code development?
Explain the different lookup methods used in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Enlist few areas or real-time situations where informatica is required.
Tell me about MD5 functions in informatica
draw informatica architecture 8.6 ?
Why union transformation is an active transformation?
