Answer Posted / shilpasagar

To run a job on 8 node that is previously run on 4 node,
you need to change the cofiguration file.

Open the job in designer -> Go to Tools -> Configurations

Create new Confuguration file such that it contains 8 nodes
with multiple pools.

with in yout job, open the stages and click on
configuration file, which will have list of configuration
files available for the project. select the one that in
which u have included 8 nodes.

compile and run the job. Now the job will run on 8 nodes
configuration.


If u want all the jobs in the project to run on 8 nodes
config .. then update APT_CONFIG_FILE env variable with the
name that is given to 8 nodes config file.

what is use of SDR function?

5173

---

Define meta stage?

1205

---

How many areas for files does datastage have?

1154

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2046

---

Can you explain repository tables in datastage?

1411

---

Explain ibm infosphere information server and highlight its main features?

1091

---

What are the repository tables in datastage?

1309

---

Describe the architecture of datastage?

1010

---

how many rows sorted in sort stage by default in server jobs

3997

---

Distinguish between informatica & datastage. Which one would you choose and why?

1010

---

How to reverse the string using SQL?

1533

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2179

---

What is the difference between validated and compiled in the datastage?

1293

---

Give an idea of system variables.

1036

---

What is the different type of jobs in datastage?

977

---