How to add zero "0" before record in a field?

4 Answers  

---

What are the differences between datastage and informatica?

0 Answers  

---

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---

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 run jon in unix back round process what is command use in runing a job?

2 Answers   HSBC,

---

4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail

1 Answers  

---

Define data aggregation?

0 Answers  

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

Can we use target hash file as a lookup ?

0 Answers  

---

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

3 Answers   IBM,

---

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

---