in my source table i want to delete first and last records and
load in between records into target? how can it possible?

Answer Posted / davankumar

In the aggregator t/r we have aggregate functions first and
last.with these we have to calculate.

Is This Answer Correct ?    3 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x at the developer level?

844


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

826


How do you load alternate records into different tables through mapping flow?

1601


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2341


Different circumstance which drives informatica server to expel records?

758


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6963


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

908


Mention a few design and development best practices for informatica?

767


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1886


How can you generate reports in informatica?

794


What is olap (on-line analytical processing?

854


can anyone explain me about retail domain project in informatica?

7725


tell me the rules and responsblites in our project(my project is development)

1736


What is a stored procedure transformation?

817


Explain incremental aggregation in informatica

889