Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / jayasankarraju

Answers were Sorted based on User's Feedback



I have source table 100 records after run session successfully but loads the target table 50 records..

Answer / shiva

just truncate table once and run the session again (or)
in session properties just checke the recovery stratagy as
resume from last check point

if i am wrong plese currecct me

Is This Answer Correct ?    4 Yes 1 No

I have source table 100 records after run session successfully but loads the target table 50 records..

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

I have source table 100 records after run session successfully but loads the target table 50 records..

Answer / guest

use dynamic lookup cache so that u can load the data after
load 50 records

Is This Answer Correct ?    1 Yes 0 No

I have source table 100 records after run session successfully but loads the target table 50 records..

Answer / sunny

Did you check if there is any filter in between ?

Is This Answer Correct ?    0 Yes 0 No

I have source table 100 records after run session successfully but loads the target table 50 records..

Answer / lakshmi

If no errors, check if you have set "test rows" to 50 in session property.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is dimension table?

17 Answers  

What is limitations of truncate and load option

1 Answers   Cap Gemini,

what is metadata?

6 Answers  

WAT IS TEXT LOAD?

3 Answers   Wipro,

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,




why u go for dimensions ?

3 Answers   TCS,

Explain the aggregator transformation?

0 Answers  

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

What is Session and Batches?

0 Answers   Informatica,

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

What is rank transformation in informatica

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories