Answer Posted / pooja

Nodemap constraint is a property check in the stage. The
job process can restriced at a stage level with this check.
It provides a drop down list of nodes available and by
selecting a particular node the process only on that
particular node.

For example, if the incoming data is being processed in
parallel mode then in the next stage if the nodemap
constraint is checked then from here on the processing
takes place in a sequential mode.

What are orabulk and bcp stages?

1110

---

What are the primary usages of datastage tool?

1060

---

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

2027

---

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)

912

---

Can you explain link buffering?

1159

---

What is difference between server jobs & parallel jobs?

1024

---

What are constraints and derivations?

1151

---

What is oci?

1286

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2042

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

996

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3159

---

What are the steps required to kill the job in Datastage?

1201

---

What are the types of containers?

1209

---

What is quality stage?

975

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2356

---