Skip navigation
Contact Us
1464 Views 3 Replies Latest reply: Dec 11, 2012 2:31 AM by Joe . RSS
Arnab Kumar Patra Novice 27 posts since
Jan 10, 2011
Currently Being Moderated

Dec 9, 2012 9:07 PM

Running Informatica workflow in loop by using parameter.

Hi All,

 

    I've a requirement for loading a huge volume of records into pieces of files. Explain as below:

 

(1) Suppose I have 1,000,000 records in my source which having rownumber for each record.

(2) My target will have 100000 records per file as target is flatfile. That means I've to generate 10 target having 100000 records each.

(3) The number of target files will be varied and I have script to check the count.

(4) While I'll rune Informatica workflow it should run as many times as the count of target file generation (for eg: 10)

(5) Each time the wokflow will run, my Source Qualifier have to check the last rownumber processed in the last run and I've to hold the last rownumber inot my parameter file dynamicaaly after each seesion load.

 

  My questions are:

 

(1) How to update the same parameter file after each session automatically?

(2) How to implement the loop/ counter while running the workflow?

 

Your early suggestion will be appreciated. Thanks in advance.

 

Regards,

Arnab.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points