Answer Posted / srinu

1) using external filter we use command is sed we get
2)select * from (select rownum rno,emp.* from emp)
where rno in(5,6,7)
or
select * from (select rownum rno,emp.* from emp)
where rno between 5 and 7
or
select * from emp where rownum<8
minus
select * from emp where rownum<5
in first two are very efiiciency compare to third one
because in third iam using set operator
3)select * from emp where rowid=(select max(rowid) from emp);

What are the difference types of stages?

1214

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1087

---

project Steps,hits, Project level HArd things,Solved methods?

2131

---

Name the different types of Lookups in Datastage?

1257

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1388

---

Define Job control?

1145

---

Can you explain repository tables in datastage?

1407

---

How can you write parallel routines in datastage PX?

1015

---

Have you have ever worked in unix environment and why it is useful in datastage?

1133

---

Define ds designer?

1277

---

Have you used Unstructured data?

1319

---

What could be a data source system?

1008

---

whom do you report?

1930

---