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
- 14751 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
Explain lookup transformation is active in informatica
What is informatica? Why do we need it?
During the running session, output files are created by informatica server. Enlist few of them.
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is the way to execute pl/sql script using informatica mapping?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
explain about unit testing? in real time?
what are factless facts? And in which scenario will you use such kinds of fact tables.
design of staging area?
How do you change a non-reusable transformation to reusable transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the need of an ETL tool?
what is informatica metadata?
What is rank transform?
How many numbers of sessions can one group in batches?
