set commit interval as 100 in WF session and commitType as target

Hi All,

I've 110 records in my table but 101 records contains an
error. When I run the session, I want to load the 100
records into the target. Can anyone suggest me the best
solution for this...

Thanks in Advance,

Question Posted / ankit gupta

7 Answers
16521 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / ankit gupta

set commit interval as 100 in WF session and commitType as
target

Is This Answer Correct ?

15 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is workflow manager?

1029

What is a joiner transformation?

969

What are pre and post-session shell commands?

1290

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1219

what is song in infrmatica...?

2218

Define mapplet?

998

tell me the rules and responsblites in our project(my project is development)

1918

How many numbers of sessions can one group in batches?

1052

Explain in detail about scd type 1 through mapping.

1426

Differentiate between sessions and batches?

1002

What are the tasks that can be performed using sq?

1078

How to delete duplicate row using informatica?

1019

What is persistent lookup cache?

1015

What is meant by a domain?

1111

What are the issues you have faced in your project? How did you overcome those issues?

2346