In reply to saurabh.

Hi Saurabh,
Thank you for following my blog and asking relevant questions.

1. Yes, when you have YARN infrastructure, you use resource manager for job tracker parameter. In the example you can notice I have used "jobtracker=xxxxx.xxxx.sas.com:8032' ". In my test environment, the resource manager is availabe on port 8032.

2. The oozie wokflow.xml file will get created upon execution of PROC SQOOP statement. The oozie workflow.xml file should be located at HDFS location specified with 'wfhdfspath' variable. In the example, I have wfhdfspath='hdfs://xxxxx.xxxx.sas.com:8020/user/sasdemo/myworkflow.xml' , so the file should be located at /user/sasdemo HDFS folder. If you are not able to see the file at specified location, verify the user permission for the folder. The user you are using to connect hadoop cluster "hadoopuser='sasdemo' " should have read and write permisison on folder specified under "wfhdfspath=" variable.