Answer Posted / sandeep.t nizamabad
OLTP SYSTEMES CONTAINS
1.FLAT FILES
2.DBASE
3.ORACLE
4.SAP
WE WILL EXTRACT THE DATA FROM OLTP TO STAGING LAYER
AND CONVERT THE DATA FROM INCONSISTENT TO CONSISTENT FORM
BEFORE LOADING TO DWH.
DWH IS NOTHING BUT OLAP SYSTEMS
IT CONTAINS DEPTS. LIKE FINANCE,SALES,PURCHASE,H.R
DATA MARTS ARE SUBSETS OF AWHWHICH ARE USED TO SATISFY THE
REPORTING REQUIREMENTS OF A DEPTS
Eg: SALES , FINANCE,PURCHASE,HR
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Explain what is full load & incremental or refresh load?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain what is cost benefit analysis (cba)?
What are different deliverables according to phases?
What are the steps of implementing data warehousing?
Is there any default username & pwd for bo designer & supervisor?
How to pivot data using informatica when you have variable amount of pivot rows?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is hybrid slowly changing dimension?
What is type 2 version dimension?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Explain the difference between view and materialized view?
