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
- 14795 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
tell me 5 session failure in real time how can you solve that in your project?
what is the size of u r source(like file or table)?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Define enterprise data warehousing?
Clarify the utilization of aggregator cache record?
What are the tasks that can be performed using sq?
EXL informatica Questions
Explain scd type 3 through mapping.
What is dimensional table?
What is a stored procedure transformation?
How can you validate all mappings in the repository simultaneously?
Can u generate reports in Informatica?
How can you define user defied event?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
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.
