If i have 10000 records, My question is now i want to send 1000 records to target each time, how?(source is Flatfile and target is flatfile)

  • Interview Candidate
  • 2
  • 1277

Showing Answers 1 - 2 of 2 Answers

Rajesh

  • Oct 10th, 2006
 

Yes, we have different logic to accomplish this thing in Informatica. You use either sequence generator and Filter transformation or Expresion and Fileter transformation. If you are sorting and loading it into target use sorter and filter. if the source is any data base then use row coun < 100 in expression and filter. I think now you job is done.

Regards,

Rajesh

  Was this answer useful?  Yes

sanjeev

  • Aug 6th, 2007
 

In session properties we have the target commit interval. There we need to mention the commit interval as 1000.


Sanjeev

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions