Answer Posted / shweta
One clarification to the fisrt point,it ingnores the commit
point only while loading to Sybase and DB2 whereas for
Oracle and SQL Server, it commits data at each commit
interval and start a new transacton after each commit.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Explain what are the advantages data mining over traditional approaches?
Can you brief about the Data warehouse project you worked on?
What are snapshots? What are materialized views & where do we use them?
Explain what are conformed dimensions?
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?
Explain how many ways you create ports?
What is fact less fact table? Where you have used it in your project?
Database in use is oracle?
what are the different views that are considered when building an object-oriented software system?
Explain why dimenstion tables are denormalized in nature?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is loop in data warehousing?
Explain bus schema?
Explain what are components of reportnet?