Answer Posted / pappu kumar

The main difference is in 7.5 we can open job only once at a system but in 8.1 we can open on job in multiple time as a read only mode and another difference is in 8.1 having Slowly Changing Dimention stage and Repository are there in 8.1.

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

2330

---

What is the differentiate between data file and descriptor file?

1410

---

State the difference between an operational datastage and a data warehouse?

1178

---

Describe the main features of datastage?

1122

---

What is the command line function to import and export the ds jobs?

1189

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2870

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074

---

how to implement scd2 in datastage 7.5 with lookup stage

5663

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3214

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1428

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

819

---

Nls stands for what in datastage?

1233

---

Notification Activity

1456

---

What are the main features of datastage?

1349

---

What is oci?

1352

---