Answer Posted / katru prasad

By changing the Link orders in the Join stage.

What is job control?

1035

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2661

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1197

---

What are sequencers?

1059

---

How to clean the datastage repository?

1071

---

What are datastage sequences?

1058

---

CHANGE CAPTURE

1258

---

What is ds designer?

1030

---

Differentiate between data file and descriptor file?

989

---

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

2408

---

What is the difference between operational data stage (ods) and data warehouse?

1178

---

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?

2133

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1508

---

What is oci?

1259

---

How can we improve performance of data stage jobs?

967

---