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 |
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
which cache supports connected & un connected Lookup
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
where the log files or tables can store in DS?
what is datastage job Monitoring
what are the devoleper roles in real time? plz tell i am new to datastage....
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Hai..,in datastage how to explain project in interview?please explain any domain please.
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb