Answer Posted / mahesh

If you dont know the PID, try below:

ps -ef|grep USER_ID|grep JOB_NAME

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2418

---

What are the steps required to kill the job in Datastage?

1271

---

What are stage variables, derivations and constants?

1285

---

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)

2782

---

What is the process of killing a job in datastage?

1072

---

How a routine is called in datastage job?

1166

---

How do you schedule or monitoring the job?

1271

---

How many types of hash files are there?

1238

---

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

826

---

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

1433

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3022

---

What is the difference between an operational datastage and a data warehouse?

1214

---

What is process model?

2027

---

whom do you report?

1986

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2779

---