Answer / 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

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

how do u capture duplicates through sort & transformer

4 Answers  

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

Nls stands for what in datastage?

0 Answers  

---

how many write modes are there in ds

2 Answers   IBM,

---

Explain connectivity between datastage with datasources?

0 Answers  

---

What modeling tool do you use?

6 Answers   HP,

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---