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 |
What are the steps needed to create a simple basic datastage job?
WHAT IS FORCE COMPILE?
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
what is the exact difference between dataset and fileset in datastage?
How to create environments and call them? What is the use defined variables?
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
What are the enhancements made in datastage 7.5 compare with 7.0?
If the job aborted in a sequencer, how can we start that from the previews successful job.
How many types of sorting methods are available in datastage?
Is the value of staging variable stored temporarily or permanently?
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?