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 to import vsam files from source to target. Do we need a special plugin?

935

---

Explain the hierarchies level data warehousing.

887

---

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1070

---

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1007

---

Explain normalization?

1137

---

Explain ddl (data definition language)?

1012

---

What is a core dimension?

1072

---

Explain what is the difference between view filter and report filter?

982

---

What is the differences between star and snowflake schemas?

1067

---

Explain what is the limit to the number of sources and targets you can have in a mapping?

1005

---

How to handle multi value dimensions?

2293

---

How can you implement many relations in star schema model?

1003

---

Explain the difference between oltp and olap?

1127

---

I need a good brd and uc template?

1087

---

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1061

---