Answer Posted / punit

New version of datastage was IBM WebSphere datastage 8.1.0
PX
the diffrence with the earlier version is that it has
parallel jobs rather then having just server jobs and for
this purpose it contains a parallel server..

What is difference between join, merge and lookup stage?

1153

---

Where do you see different stages in the designer?

1147

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1277

---

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

1271

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1135

---

How do you schedule or monitoring the job?

1271

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2551

---

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

1585

---

What all are the different way to run a job?

1144

---

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

1078

---

How one source columns or rows to be loaded in to two different tables?

1180

---

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.

4098

---

What is the difference between datastage and informatica?

1186

---

What is the difference between hashfile and sequential file?

1322

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3296

---