Answer Posted / 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

Explain how are the dimension tables designed?

987

---

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5603

---

What is dimensional modelling?

930

---

How do you define data block size?

988

---

What is a view as it relates to system modeling?

936

---

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

921

---

What is normalization, first normal form, second normal form, third normal form?

912

---

How many types of facts and what are they?

953

---

Explain difference between e-r modeling and dimentional modeling?

917

---

Database in use is oracle?

1005

---

What is Cognos script editor?

2482

---

How do you setup Lo-cockpit?

3079

---

How to drill through from a powerplay cube to reportnet?

875

---

What is defined as partial backup?

1023

---

What is the difference between aggregate table and materialized view?

1031

---