⟩ What are the steps involved in Database Startup?
Start an instance, Mount the Database and Open the Database.
Start an instance, Mount the Database and Open the Database.
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
Explain What is the difference between Power Center & Power Mart?
Explain What are the various transformation available?
Tell me what is Full load & Incremental or Refresh load?
Explain Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Explain the difference between keylokup and joiner?
Explain and Compare ETL & Manual development?
Explain the difference between etl tool and olap tools?
Explain What are the modules in Power Mart?
How to extract SAP data Using Informatica? What is ABAP? What are IDOCS?