can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,

---

Lookup constraints

0 Answers   CTS,

---

What is the use of surrogate key stage?

2 Answers  

---

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

0 Answers  

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

Define Merge?

0 Answers  

---

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

---

what is sparse lookup?

7 Answers   IBM,

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

Differentiate between datastage and informatica?

0 Answers  

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---