Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT are unix quentios in datastage
- 2 Answers
- 20281 Views
- TCS, I also Faced
- E-Mail Answers
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 |
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
What are the various kinds of the hash file?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
How to perform incremental load in datastage?
can we use sequential file as a lookup
What is orabulk stage?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
Differentiate between operational datastage (ods) and data warehouse?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
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 ?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
Teradata 
