1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how?
2.how to schedual the job in datastage7.5 2?
what is the deff bet grip and fgrep command?
how do you cleanse the data in your project
Answer / don
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how?
Jobs 1 to 5 are associated into a master seq. for the job activity 1 and 2 we can have "reset" or "validate" option activated and for the jobs 3, 4, 5 we will have "reset if failed then run". Later schedule the Master seq to run as needed.
2.how to schedule the job in datastage?
Go to director Client: choose time line to schedule Master seq or jobs..
many options via 3rd party scheduling tools like: ControlM, TWS, CAWA Autosys etc
what is the diff bet grip and fgrep command?
the fgrep command searches for fixed-character strings in a file or files. "Fixed-character" means the string is interpreted literally — metacharacters do not exist, and therefore regular expressions cannot be used.
how do you cleanse the data in your project
By applying Trim IsNull Convert Field etc functions can be utilized to cleanse the raw data either in tables via SQL or Tfm in DataStage for files based
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the importance of the exception activity in datastage?
What are the types of hashed files in data stage
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is Cleanup Resources and when do you use it?
describe the Steps to confiure a Qlogic switch
How to read the length of word in unix?
How you can fix the truncated data error in datastage?
Is there any possibility to generate alphanumeric surrogate key?
what is advantages of snowflake when it is used?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
Explain datastage architecture?
What is the difference between operational data stage (ods) and data warehouse?