Answer Posted / sriharsha vemuri

Datastage jobs determine which node to run the process on,
where to store the temporary data, where to store the
DATASET data, based on the entries provide in the
configuration file

Based on the entries provide in the configuration file the
decision for storing the Dataset date happens.

options available in sequence job to run,validate?

1320

---

How to read the length of word in unix?

1380

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2446

---

sed,awk,head

1467

---

Define data aggregation?

1102

---

How a server job can be converted to a parallel job?

1096

---

Name the different sorting methods in datastage.

1050

---

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)

2730

---

What are the different options associated with dsjob command?

1441

---

How many types of hash files are there?

1185

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2505

---

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

1382

---

What is the difference between datastage and informatica?

1118

---

How to read multiple files using a single datastage job if files have the same metadata?

1252

---