Answer Posted / hemachandra

I believe there is no difference between server shared
container and parallel stage container since server shared
container having server stages and parallel shared
container having parallel stages.

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

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1661

---

What is the command line function to import and export the ds jobs?

685

---

Why fact table is in normal form?

683

---

Can you define merge?

670

---

---

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.

3505

---

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

609

---

If you want to use a same piece of code in different jobs, how will you achieve this?

800

---

What is usage analysis in datastage?

821

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1934

---

Difference between in process and inter process?

704

---

Differentiate between data file and descriptor file?

621

---

What is the difference between account and directory options ?

628

---

Explain ibm infosphere information server and highlight its main features?

615

---

What is the difference between Datastage 7.5 and 7.0?

679

---