Answer / sreenath

I'm not sure .......
In Oracle database target stage u have a options insert/upsert option u can put that option everything false into place

How complex jobs are implemented in datstage to improve performance?

0 Answers  

---

How do you design PX Routines ?

1 Answers  

---

What is the different type of jobs in datastage?

0 Answers  

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

---

Have you used Unstructured data?

0 Answers   CTS,

---

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

---

Main Function of the Staging area in DWH ?

2 Answers  

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---

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

4 Answers   HSBC,

---

How do you import and export data into datastage?

0 Answers  

---