Answer Posted / shreeram

Seq(source)------> Transform stage-------> Tgt1
!.........>Tgt2


use substring in transform stage.

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2204

---

What all the types of jobs you developed?

1177

---

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

3163

---

What is quality stage?

985

---

What is the different type of jobs in datastage?

966

---

How do you import and export the datastage jobs?

1157

---

Demonstrate experience in maintaining quality process standards?

2542

---

Can you explain tagbatch restructure operator?

1168

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4036

---

What are the repository tables in datastage?

1301

---

what is ds administrator used for?

1164

---

What are the some differences between 7.x and 8.x version of datastage?

1253

---

Differentiate between data file and descriptor file?

1049

---

What is the difference between passive stage and active stage?

1525

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2247

---