Answer Posted / vinod upputuri

You are right chetan, but in the second lookup we have to
use seq file 1 for main link and o/p2 is linked as reference.

What are the important features of datastage?

1128

---

How can we improve the performance in datastage?

1105

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

---

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

1540

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416

---

How do you import and export the datastage jobs?

1161

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

---

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.

4044

---

Differentiate between data file and descriptor file?

1063

---

Define Routines and their types?

1189

---

Can you filter data in hashed file?

3778

---

How can you write parallel routines in datastage PX?

1016

---

What is quality stage?

990

---

How do y read Sequential file from job control?

15969

---

What is the difference between the local container and shared container?

1106

---