Answer / srinivas

Both the files are used for look up purpose but Hash file is in server edition and witch we don't have in parallel edition.


Same Look up file also existed in parallel not in server edition.

In both files we have to give the key column.

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

What all are the different way to run a job?

0 Answers  

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

Differentiate between Join, Merge and Lookup stage?

0 Answers  

---

---

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---

How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,

---