If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

0 Answers  

---

How to provide security in frame work manager for a query subject?

0 Answers  

---

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

0 Answers  

---

What are the steps involved in creating dimensional modeling process?

0 Answers  

---

waht is the advantage of infoset query

0 Answers   iGate,

---

Explain how to generate iqd file from framework manager?

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,

---

why oracle is the best database for data warehousing?

4 Answers   HCL,

---

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?

0 Answers  

---

What is the difference between metadata and data dictionary?

0 Answers  

---

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

0 Answers  

---

5.Explain ODS ?

3 Answers   HCL,

---