Answer Posted / kiran

hai sagar,gourav and natasha..,Ur answer is correct but my
quetion is wrong .
my reqment is, i am having multiple sources(flatfies)
and sources metadata same and poulated to target without
using funnel stage

How can one find bugs in job sequence?

1418

---

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

1384

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5125

---

What is the method of removing duplicates, without the remove duplicate stage?

1029

---

Define orabulk and bcp stages?

1124

---

How do you import and export data into datastage?

1237

---

What is the difference between in process and inter process?

1153

---

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?

2237

---

Why do we use exception activity in Datastage?

1317

---

Define APT_CONFIG in Datastage?

1084

---

What is ds designer?

1107

---

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

---

What is ibm datastage flow designer?

1151

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1503

---

What all the types of jobs you developed?

1181

---