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

Answer / subhash

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

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 Answers  

---

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  

---

What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  

---

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

---

What is audit table?

1 Answers  

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

---

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

---

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

---

client know skid info?

0 Answers   NTT Data,

---

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,

---