Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4581 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
Name the third party tools that can be used in datastage?
Explain Quality stage?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
How do u call shellscript/Batch file from DS?
Describe link sort?
What is difference between join, merge and lookup stage?
What is difference between 8.1 , 8.5 and 9.1 ?
what is the use of surogate key in datastage
Teradata 
