Answer Posted / ramjanaki

The main advantage of Stage Variables is to reduce the
repetition of the code for all the required columns in the
Transformer.
Say for Example, if you are having 10 lines of code to
be used for all the derivations of columns in the
transformer, we declare a Stage variable once and we assign
these 10 lines of code to that variable and can place this
Stage variable where ever needed in the derivation of the
columns in the Transformer Stage. Th scope of these
variables is limited with in the stage it is created.

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1705

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

606

---

What is the importance of the exception activity in datastage?

630

---

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

707

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1041

---

---

What are the different kinds of views available in a datastage director?

609

---

Explain connectivity between datastage with datasources?

605

---

root tree will find which is server job and which is parallel job?

1459

---

What are the functionalities of link collector?

630

---

Describe the main features of datastage?

662

---

Notification Activity

903

---

what is the difference between == and eq in UNIX shell scripting?

981

---

What is the difference between passive stage and active stage?

829

---

What are the different types of lookups in datastage?

634

---

What is staging variable?

626

---