Answer Posted / subhash

In DataStage:
SRC--->CPY---->JOIN----TFM---TGT
--------|---- /
--------|--- /
--------|-- /
--------|- /
--------AGG
In AGG, GROUP BY EmpId, calculate MIN and MAX for each
EmpId.
JOIN both one copy from CPY and 2nd Aggrigated copy from
AGG.
In TFM, put constraint: IF MIN=MAX, then populate to TGT
then u will get required output.

options available in sequence job to run,validate?

1327

---

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

1036

---

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

2455

---

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

1547

---

Where do you see different stages in the designer?

1104

---

What is staging variable?

1107

---

What is the use of datastage designer?

1161

---

What are routines in datastage? Enlist various types of routines.

1103

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1224

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2489

---

Difference between in process and inter process?

1242

---

How to reverse the string using unix?

3520

---

Differentiate between datastage and datastage tx?

1063

---

What are the types of containers in datastage?

1196

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1755

---