Tell me what is full load & incremental or refresh load?

0 Answers  

---

what is difference between scd2 and scd3

3 Answers  

---

Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best

2 Answers   L&T,

---

What are CUBES?

2 Answers  

---

Why joiner transformation does not allow the aggregator transformation and expression transformation to join

2 Answers  

---

Explain what is the difference between powerplay transformer and power play reports?

0 Answers  

---

What is the difference between narmal load and bulk load?

1 Answers  

---

Explain the definition of normalized and denormalized view and what are the differences between them?

0 Answers  

---

What is the very basic difference between data warehouse and operational databases?

0 Answers  

---

Where we use surrogate key explain with example?

0 Answers  

---

What is the difference between metadata and data dictionary?

0 Answers  

---

Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

1 Answers   Principal Finance, PT Metalogix Infolink Persada,

---