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

What is difference between server jobs & parallel jobs?

631


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2850


What is the difference between datastage and informatica?

620


What is active and passive stage?

889


Why do we use link partitioner and link collector in datastage?

689






Explain connectivity between datastage with datasources?

605


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2019


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1638


What are the components of ascential data stage?

656


Difference between in process and inter process?

706


What is the different type of jobs in datastage?

583


How can we improve the performance in datastage?

656


How do u convert the columns to rows in datastage?

696


What is the use of datastage director?

595


how to implement scd2 in datastage 7.5 with lookup stage

5139