Answer Posted / chowdary

Take 2 sequentalfiles target dataset and processing funnel
stage.

note: Take similar structure we need common column names,
common datatypes then merging this process.....

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.

4044

---

Difference between sequential file and data set?

1205

---

Define ds designer?

1283

---

How and where you used hash file?

1175

---

What are the difference types of stages?

1216

---

Is possible to create skid in dim,fact tables?

2637

---

What steps should be taken to improve Datastage jobs?

1073

---

Difference between in process and inter process?

1240

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2234

---

What are stage variables?

1204

---

How do u convert the columns to rows in datastage?

1194

---

How do you schedule or monitoring the job?

1210

---

Why do you need stage variables?

1181

---

Have you have ever worked in unix environment and why it is useful in datastage?

1133

---

Why we use surrogate key?

1236

---