If a session fails after loading of 10,000 records in to the
target. How can you load the records from 10001 th record
when u run the session next time?
Answer Posted / srini
By setting session property as Resume last check point you
can acheive the same.Make sure that all recovery tables
PM_RECOVERY,PM_TGT_RUN_ID is created in the target database
or Realtion connection User have the
create,grant,insert,update previliages on target database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Write the advantages of partitioning a session?
What are session parameters ? How do you set them?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to extract sap data using informatica? What is abap? What are idocs?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Where are the source flat files kept before running the session?
Informatica Checkpoints
What is olap (on-line analytical processing?
Can informatica load heterogeneous targets from heterogeneous sources?
What are some examples of informatica etl programs?
What is the format of informatica objects in a repository?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
can anyone suggest best free Talend data integration training online
Different circumstance which drives informatica server to expel records?