Datawarehouse Architect

Explain what is ORACLE DATA INTEGATOR? why is it different from the other ETL tools. Ans 1: ORACLE DATA INTEGATOR stands for Oracle Data Integrator. It is different from another ETL tool in a way that it uses E-LT approach as opposed to ETL approach. This approach eliminates the need of the exclusive Transformation Server between the Source and Target Data server. The power of the target data server can be used to transform the data. i.e. The target data server acts as staging area in addition to its role of target databasel. While loading the data in the target database (from staging area) the transformation logic is implemented. Also, the use of appropriate CKM (Check Knowldege Module) can be made while doing this to implement data quality requirement. Q3.How will you bring in the different source data into ORACLE DATA INTEGATOR? you will have to create dataservers in the topology manager for the different sources that you want. Q4.How will you bulk load data? In ORA

 1.   Class room training for OBIEE will be given for student who located in Chennai, India.  2.   OBIEE certification training will be given with assurance of getting minimum 90%         3.   OBIEE Online training will be given for USA students in evening timings.  4.   OBIEE training tutorials will be provided at the time of training. OBIEE TRAINING  5. Contact me at +91-9994883085, Skype - kashif7222, Email ID - coogle7222@gmail.com  Kindly find below syllabus for OBIEE 11g Training: Repository Development ü   Repository Basics 1.        Architecture Of OBIEE 2.        Data Sources 3.        Repository – Admin Tool 4.        Physical Layer and its Objects 5.        Business Model and Mapping layer and its Objects 6.        Measures 7.        Presentation Layer and its Objects 8.        Repository Modes 9.        Repository Directory 10.    Publishing Repository ü   Building Physical Layer 1.        Database