when i was running the seesion, after loading 100 records,
session suddenly fails.Next time i want to load the remaing
rows in target with out truncate target table.What should i
use?

Answer Posted / dhananjaya

use transaction control transformation

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

EXL informatica Questions

943


Separate from an archive server and a powerhouse?

506


What is the advantage of informatica?

657


Describe the impact of several join conditions and join order in a joiner transformation?

656


can anyone explain me about retail domain project in informatica?

7447






How to generate sequence numbers using expression transformation?

652


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1715


Explain transaction control transformation in informatica

771


Why update strategy and union transformations are active?

604


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

800


What are the prerequisite tasks to achieve the session partition?

722


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1851


What is the difference between a repository server and a powerhouse?

826


In development project what is the process to follow for an etl developer from day1

1292


Which transformation is needed while using the Cobol sources as source definitions?

736