Answer / swetha

Two ways

1. Edit the definition

2. Reimport the defintion

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

What is the function of look up transformation?

0 Answers  

---

---

Separate from a database, an information bazaar, and an information stockroom?

0 Answers  

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---

What is update override?

1 Answers   Accenture,

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

where to select code page option?

2 Answers   TCS,

---