Answer / pawan

Sky Info Technologies Pvt. Ltd. Is a premier company engaged
in IT Services Training, Corporate Training, Industrial
Training, Individual Training ERP Oracle Training, software
development Consultancy, Recruitment. & Man power Outsourcing.
SKY INFO TECH provides training in Data Ware Housing
(Informatica/Etl,Cognos,Bo) and Job Assistance of placement
for its students. Sky provides training in Data Ware Housing
(Informatica/Etl,Cognos,Bo) Experienced Working
Professional. This training is also supported with the help
of live projects in Data Ware Housing which provides
industrial exposure to the candidates & helps the Candidate
to finding a suitable job in Data Ware Housing. We have a
dedicated placement cell which provides placement assistance
in to all the Data Ware Housing (Informatica/ Etl,Cognos,Bo)
candidates.

Thanks & Regards,
Corporate Office:
Sky Info Technologies Pvt. Ltd.
A-50,Sec-64,Noida(U.P)
Contact-----------------------------------------------------
Noida- 0120 4242223/24, 9717292598/9717292599
Delhi – 9717292601/9717292602
Gurgaon – 9810866624/9810866642

what is query optimizer? what are different types of optimizer s supported by oracle ?

1 Answers   ABC,

---

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

0 Answers  

---

Difference between DSS & OLTP?

6 Answers   IBM,

---

What are various warehousing tools?

0 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,

---

---

Explain what is data validation strategies for data mart validation after loading process?

0 Answers  

---

explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

3 Answers   IBM, Ness Technologies,

---

What are the advantages and disadvantages of reporting directly against the database?

0 Answers  

---

Explain the difference between dw and bi?

0 Answers  

---

What is staging area?

9 Answers  

---

what are the other factors of the database on which the loading performance depend?

0 Answers  

---

what is the difference between aggregate table and fact table ? how do you load these two tables ?

12 Answers   Target,

---