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
16581 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

How are the sources and targets definitions imported in informatica designer?

1107

Explain the tuning lookup transformation - informatica

994

Repository user profiles

1762

What is the reusable transformation?

1047

What is a joiner transformation and why it is an active one?

1080

what is Active lock explain

2799

server hot-ws270 is connect to Repository B. What does it mean?

2565

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

As union transformation gives UNION ALL output, how you will get the UNION output?

1108

Parameter and variable differences

2062

Differentiate between a database and data warehouse?

1143

Explian the Process of deployment groups in informatica

1062

wf dont have integration severances how you can run?

1938

What is a filter transformation?

1043

According to his methodology what all you need before you build a datawarehouse

1757