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 |
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
What is a merge?
What is difference between join, merge and lookup stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the some differences between 7.x and 8.x version of datastage?
what is the unix script to run the job? Please mention commands which we use often?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
why dataset ?
What are the areas of application?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?