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
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 mean by complex business rule ?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain how many types of dimensions are available in informatica?
Enlist the tasks for which source qualifier transformation is used.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Define sessions in informatica etl?
What is the benefit of partitioning a session?
How many ways a relational source definition can be updated and what are they?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is standalone command task?
What are the various types of transformation?
scenario where i can use only concurrent execution of workflow.
How do you convert single row from source into three rows into target?
What are the types of data warehouses?
How to Create a folder using pmrep command?