How do u call shellscript/Batch file from DS?
Answers were Sorted based on User's Feedback
Answer / jack
You can invoke shell script through Job Properties -->
Before Job routine --->ExecSH
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / datastage4you
there are diff ways to call..
if Seq job :
Use command stage to call a shell script
or if job
go to the job properties and select "Before/After job
routine" and use ExecSH options to invoke shell script.
Thanks
http://datastage4you.blogspot.in/
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kiran
Well answer from Jack and u can call from another way.go to
Job Properties and ther r one option is ther like
APT_CONFIG_file Tab is there do to user defined and select
Search Shell Path
Is This Answer Correct ? | 2 Yes | 9 No |
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
What is the difference between validated and compiled in the datastage?
why we use hash file for lookup?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
What is a merge?
DataStage Scenario based Interview Questions
how to cleansing data
What is Horizontal transformation, vertical transformation,diagonal transformation?
What are the types of views in datastage director?
How to implement complex jobs in data stage?
Which algorithm you used for your hashfile?