what is dimension table?

17 Answers  

---

What is the functionality of update strategy?

2 Answers  

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

---

---

what are the types of Data warehousing ?

1 Answers  

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

what is the exact meaning of domain?

3 Answers  

---

scd methodology?

2 Answers  

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---