Answer Posted / balaji

these are mostly used in real time scenario:
database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage.

debugging stage are:
1.head stage
2.tail stage
3.peek stage

Define APT_CONFIG in Datastage?

1054

---

How to reverse the string using SQL?

1494

---

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

1213

---

What is the difference between passive stage and active stage?

1505

---

Explain usage analysis in datastage?

1142

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1132

---

How to RD using transformer?

1405

---

What are the repository tables in datastage?

1288

---

What are stage variables?

1187

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2075

---

What are stage variables and constants?

1126

---

Terminate Activity

1259

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2879

---

Can you highlight the main features of ibm infosphere information server?

1077

---

What a datastage macro?

1044

---