Answer Posted / subhash

1) configuration file structure:
{
node "node1"
{
fastname "<SERVER_NAME>"
pools ""
resource disk "</dsg/IBM/..DATASETS Path>" {pools
""}
resource scratchdisk "</dsg/..Scratch disk/Buffer
Path>" {pools ""}
}
node "node2"
{
fastname "mctux034"
pools ""
resource disk
"/dsg/IBM/IBM/InformationServer/Server/Datasets" {pools ""}
resource scratchdisk
"/dsg/IBM/IBM/InformationServer/Server/Scratch" {pools ""}
}
}
2)
SRC--->COPY---->TGT
Here Copy stage increase performance and works as a Buffer
when diff in reading count and writing record count.
by setting/checking below in Target ORACLE Connector:
Record Count=6000 (default is 2000, should be multiple of
Array Size)
Array Size=3000 (default is 2000)
Write mode=Bulk Load
Rebuild Indexes After Bulk Load

How can we improve the performance in datastage?

1059

---

What is process model?

1919

---

What are orabulk and bcp stages?

1065

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3730

---

Can you explain tagbatch restructure operator?

1114

---

How you can fix the truncated data error in datastage?

1673

---

Can you explain link buffering?

1104

---

How many types of stage?

1131

---

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

725

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

863

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1170

---

how to abort the job its matain duplicates?

2531

---

Give an idea of system variables.

960

---

What are the types of containers and how to create them?

930

---

What is staging variable?

1026

---