Interested to Buy Any Domain ? << Click Here >> for more details...
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
- 5 Answers
- 12272 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / ahalya inturi
"Restart the session" . if the integration service has not issued at least one commit.
(or)
perform "Session Recovery" if the integration service has issued atleast one commit.
the I.S reads row id of last row commited from OPB_SRVR from repository table.
the I.S reads all the data from source , start processing from next row id..
we can perform session recovery when only target load type is normal. it can not support in bulk loading..
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
What is domain in terms of informatica?
How to extract the informatica rejected data?
Under what condition selecting sorted input in aggregator may fail the session?
What is the sequence generator transformation in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is status code in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the main issues while working with flat files as source and as targets ?
How union transformation is used?
What is the difference between STOP and ABORT options in Workflow Monitor?
What does cheating measurement mean?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the maplet?
