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 / powerstar

session recovery works much better if it is run in normal mode.
If the load type is bulk mode, then session recovery is compromised.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by lookup transformation?

621


How many transformations can be used in mapplets.

1468


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

793


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

1512


What are roles and groups and benefits of using them?

581






Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1943


What is the difference between writing a joiner query in ANSI style and THETA style?

1931


What does “tail –f” command do and what is its use as an Informatica admin.

637


What does command task mean?

620


Which files are created during the session rums by informatics server?

718


How to extract sap data using informatica? What is abap? What are idocs?

571


EXL informatica Questions

943


what is diff b/t sorter t/r and agg have the option sorter property...

1756


Name at least 5 different types of transformations used in mapping design and state the use of each.?

686


What is difference between a gateway node and worker node?

637