How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 13243 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answer Posted / suresh
cant we write a subquery?
delete from table emp where exists (select * from emp where rownum=1 or 2 or 3);
count(empno) --> has to be stored in a variable port and delete the last three rows of the target table.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Have you worked with/created Parameter file
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Under which circumstances, informatica server creates reject files?
Explain about cumulative Sum or moving sum?
How might you approve all mappings in the archive all the while?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Mention a few design and development best practices for informatica?
What do you mean by filter transformation?
What is flashback table ? Advance thanks
Separate from an archive server and a powerhouse?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How you know when to use a static cache and dynamic cache in lookup transformation?
How can informatica be used for an organization?
How can we use mapping variables in informatica?
