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 happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

What are session parameters ? How do you set them?

0 Answers  

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

design of staging area?

0 Answers  

What do you mean by enterprise data warehousing?

0 Answers  




Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

what is the monster dimension plz give me one example

2 Answers   EDS,

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories