Answer / jeeva

compile
if it is failed in compile check the error and fix it
re-compile and execute it

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

---

what is the difference between == and eq in UNIX shell scripting?

0 Answers   CTS,

---

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  

---

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

---

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

---

State the difference between an operational datastage and a data warehouse?

0 Answers  

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

---

how many write modes are there in ds

2 Answers   IBM,

---

What is use Array size in datastage

0 Answers  

---

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

---

What is a delta record? How you will read it?

0 Answers   EDS,

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---