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 Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Notification Activity

901


Can we use target hash file as a lookup ?

2816


Explain the datastage parallel extender (px) or enterprise edition (ee)?

739


What is a datastage job?

622


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1620






Define oconv () and iconv () functions in datastage?

883


What is the difference between the local container and shared container?

651


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2182


How you Implemented SCD Type 1 & Type 2 in your project?

3699


sed,awk,head

970


Name the third party tools that can be used in datastage?

618


Explain connectivity between datastage with datasources?

599


How a server job can be converted to a parallel job?

620


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3314


Explain datastage architecture?

820