What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

---

What is the difference between lookup and sparse lookup?

1 Answers  

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

How do you run datastage job from the command line?

0 Answers  

---

Explain the ChangeApply stage?

11 Answers  

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---