what is degenerated dimension table with scenario

2 Answers   HCL,

---

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

what is shared Cache. when we will use shared Cache?

4 Answers  

---

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

State the differences between sql override and lookup override?

0 Answers  

---

How many ways are there to create ports?

0 Answers   Informatica,

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---