how to configure databases through datastage

2 Answers  

---

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

---

what is the use of materialized view?

0 Answers   CTS,

---

How to reverse the string using SQL?

0 Answers   CTS,

---

Can you filter data in hashed file?

0 Answers  

---

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

---

Difference between in process and inter process?

0 Answers  

---

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

What is the difference between passive stage and active stage?

0 Answers  

---