Answer Posted / ankit gosain

Hi,

Job will run smoothly but the dataset will run on 2 node
configuration.
This is because whenever you create a dataset, 4 componets
are created which are Discriptor file, Data file, Header
File and Control file. Now, when that dataset was created
with 2 node configuration, it captured the configuration
file into it's Discriptor file and now if you'll use that
dataset in some other environment with 4 node
configuration, it won't affect anything, since the
discriptor have the configuration of nodes when it was
creadted.
You can cross check it by using the environment variable
APT_DUMP_SCORE.
If you have further doubts or query, you can mail me at
ankitgosain@gmail.com

Cheers,
Ankit

What is staging variable?

1096

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2368

---

What is the difference between the local container and shared container?

1104

---

What is the differentiate between data file and descriptor file?

1363

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4044

---

Can you define merge?

1123

---

explain about citrix scheduling tool in datastage

2457

---

Explain the importance of surrogate key in data warehousing?

1191

---

How do you import and export data into datastage?

1235

---

Define ds designer?

1283

---

How a source file is populated?

1067

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2800

---

What are the important features of datastage?

1127

---

What are the different plug-ins stages used in your projects?

1078

---

What are some prerequisites for datastage?

1100

---