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 stages in datastage?

1043

---

what is the difference between == and eq in UNIX shell scripting?

1446

---

Why we use surrogate key?

1167

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2227

---

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

2413

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3223

---

In Datastage, how you can fix the truncated data error?

1111

---

How do you import and export the datastage jobs?

1118

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2139

---

Explain entity, attribute and relationship in datastage?

1059

---

What is the difference between an operational datastage and a data warehouse?

1097

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2236

---

What a datastage macro?

1013

---

What is apt_config in datastage?

1092

---

how to export or import the jobs in .ISX file

1142

---