How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 12746 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
Define mapplet?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are active transformations.
Where is metadata stored?
What is source qualifier transformation in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the measure objects?
What is parallel processing in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a node in Informatica?
generate date / time dimension in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
