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

How can we determine what records to extract?

1029

---

How to improve session performance in aggregator transformation?

935

---

Explain what are the vaious etl tools in the market?

871

---

What is the main difference between star and snowflake star schema? Which one is better and why?

978

---

What is surrogate key? Where we use it explain with example?

864

---

Explain what are non-additive facts in detail?

967

---

How many types of facts and what are they?

953

---

Explain what are the methodologies of data warehousing?

868

---

What is the difference between snowflake and star schema?

994

---

Explain which columns go to the fact table and which columns go the dimension table?

870

---

What is the use of dimensional modeling in data warehousing?

920

---

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1021

---

What are the advantages of cold fusion?

907

---

what type of raid setup would you put your tx logs?

888

---

Explain which are the olap tools available that are supported by oracle?

944

---