Category Archives: Oracle ETL Interview Questions

Techniques of Error Handling – Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)? | Oracle ETL Questions

Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table.These rejected records we can find in the badfiles folder where a reject file will be created for a … Continue reading

Posted in Oracle ETL Interview Questions | Leave a comment

I am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done? | Oracle ETL Questions

There are various ways of Extracting Data from Source Systems.For example , You can use a DATA step, an Import Process .It depends with your input data styles. What kind of File/database it is residing in. Storing ur data in … Continue reading

Posted in Oracle ETL Interview Questions | Leave a comment

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA? | Oracle ETL Questions

The best procedure to take a help of debugger where we monitor each and every process of mappings and how data is loading based on conditions breaks.

Posted in Oracle ETL Interview Questions | Leave a comment

What is the metadata extension? | Oracle ETL Questions

Informatica allows end users and partners to extend the metadata stored in the repository by associating information with individual objects in the repository. For example, when you create a mapping, you can store your contact information with the mapping. You … Continue reading

Posted in Oracle ETL Interview Questions | Leave a comment

What is the difference between etl tool and olap tools? | Oracle ETL Questions

ETL tool is ment for extraction data from the legecy systems and load into specified data base with some process of cleansing data. Ex: Informatica,data stage ….etc OLAP is ment for Reporting purpose.in OLAP data avaliable in Mulitidimectional model. so … Continue reading

Posted in Oracle ETL Interview Questions | Leave a comment

What is ODS (operation data source)? | Oracle ETL Questions

ODS – Operational Data Store. ODS Comes between staging area & Data Warehouse. The data is ODS will be at the low level of granularity. Once data was poopulated in ODS aggregated data will be loaded into into EDW through … Continue reading

Posted in Oracle ETL Interview Questions | Leave a comment

What are the various transformation available? | Oracle ETL Questions

  Aggregator Transformation Expression Transformation Filter Transformation Joiner Transformation Lookup Transformation Normalizer Transformation Rank Transformation Router Transformation Sequence Generator Transformation Stored Procedure Transformation Sorter Transformation Update Strategy Transformation XML Source Qualifier Transformation Advanced External Procedure Transformation External Transformation

Posted in Oracle ETL Interview Questions | Leave a comment

What is the difference between Power Center & Power Mart? | Oracle ETL Questions

PowerCenter – ability to organize repositiries into a data mart domain and share metadata across repositiries. PowerMart – only local repositiry can be created.

Posted in Oracle ETL Interview Questions | Leave a comment

What is latest version of Power Center / Power Mart? | Oracle ETL Questions

The Latest Version is 7.2

Posted in Oracle ETL Interview Questions | Leave a comment

What are the various tools? – Name a few? | Oracle ETL Questions

A few are …. – Abinitio – DataStage – Informatica – Cognos Decision Stream – Oracle Warehouse Builder – Business Objects XI (Extreme Insight) – SAP Business Warehouse – SAS Enterprise ETL Server

Posted in Oracle ETL Interview Questions | Leave a comment