write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

how do u tune queries?

1 Answers  

---

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---

what is runtime variable?

3 Answers   TCS,

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

What are Target Options on the Servers?

1 Answers  

---

What does command task mean?

0 Answers  

---

In informatics server which files are created during the session rums?

0 Answers  

---