WHAT are unix quentios in datastage
Answers were Sorted based on User's Feedback
Answer / ram
How to kill a process
1.Kill
Process status
2.ps
Regular Expresion
3.Grep
Shellscript execution
4../script name
Running Jobs
5.dsjob -run
listing out files
6.ls -lrt
these are basic questions
Is This Answer Correct ? | 13 Yes | 0 No |
1. patterns finding and replacing..
SED -n '1,$p' file_name ----> displays 1st & last line
SED -n '1,$d' file_name ----> deletes from O/P 1st & last
line. etc
2. First N records & last N records
HEAD -5
TAIL -5
3. to find word/line count in file
WC -l--- no of line
WC -w--- no of words count
4. AWK, FIND, CUT etc are also useful
Is This Answer Correct ? | 6 Yes | 0 No |
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
how to get the unique records on multiple columns by using sequential file stage only
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
What is a delta record? How you will read it?
Difference between server jobs & parallel jobs?
Is it possible to query a hash file?
how to abort the job its matain duplicates?
What are the different types of lookups in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
how many write modes are there in ds
count number of deptno in a emp table?
Differentiate between odbc and drs stage?