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
- 14486 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
What could be the possible resons of locks by user?
What are ETL Tools?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a pre-defined event and user-defined event?
What is the use of code page?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the different kinds of facts.
Write the unconnected lookup syntax and how to return more than one column.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What if the source is a flat-file?
Do you find any difficulty while working with flat files as source and target?
Where is metadata stored?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
