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

How can we use batches?

601


generate date / time dimension in informatica

717


is it possible to index the data in cache of lkp transformation ?

1521


Under what condition selecting sorted input in aggregator may fail the session?

660


Which means the first record should come as last record and last record should come as first record and load into the target file?

609






whats the logic to load the lower level of granularity of data to fact table.

1792


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.

770


Explain the informatica workflow?

585


Define sessions in informatica etl?

614


How do you load only null records into target?

739


Explain the features of connected and unconnected lookup.

543


What is the fact table?

585


What is an unconnected transformation?

660


What are the designer tools for creating transformations?

678


How to open an older version of an object in the workspace?

615