top of page
  • Writer's pictureJatin Madaan

Running Informatica workflow in a loop for different dates .

Updated: Feb 11, 2019


  1. Get parameter such as workflow_name,start_date,end_date,parameter_file as input in a file .

  2. Loop through dates to get all date values using command : while [[ "$start_date" -le "$end_date" ]]; do date -d "@$start_date" +%F; let start_date+=86400; done > date_range_${workflow_name}.txt

  3. Inside another loop (nested ) make changes to parameter file ie replace values using : sed -i 's,^\($$START_DATE=\).*,\1'"${date_value}"',' ${param_file}

  4. Run workflow in inner loop as : pmcmd startworkflow -u user_namep -p passwd -d domain -sv server -f Folder -wait workflow_name capture rc of pmcmd command and make use of it accordingly.


42 views0 comments

Kommentarer


bottom of page