Running Informatica workflow in a loop for different dates .
- Jatin Madaan 
- Feb 7, 2019
- 1 min read
Updated: Feb 11, 2019
- Get parameter such as workflow_name,start_date,end_date,parameter_file as input in a file . 
- 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 
- Inside another loop (nested ) make changes to parameter file ie replace values using : sed -i 's,^\($$START_DATE=\).*,\1'"${date_value}"',' ${param_file} 
- 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. 

Comments