Interested to Buy Any Domain ? << Click Here >> for more details...
what is a hot file, why we need in datawarehousing, where
we used in general
- 2 Answers
- 7719 Views
- Thomson, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinath rao.g
A hot file is a datasource by which we can develope .IMR
reports
.IMR reports can be developed in two ways
1.by catalog
2.by hot files
we can generate the reports by using two datasources at a
time with the help of HOTFILES.
WHERE AS does't support two datasources at a time.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shree uday
Hot File:If we generate a report from two different
database, at that time we go for Hot File.The only drawback
is it will occupy the whole space in the hard disk.
Need of DWH:if u want enterprise reporting and analysis
from your historical data.
| Is This Answer Correct ? | 2 Yes | 2 No |
Explain a relation schema and a relation?
Why fact table is in a normal form?
Explain about Control M JObs detaily?How to execute this.
2 Answers Scope International,
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Explain the difference between data ware house & data mart?
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
What is a data profile?
How can we determine what records to extract?
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?
Where we use surrogate key explain with example?
Is there any default username & pwd for bo designer & supervisor?
Can we take backup when the database is opened?
Teradata 
