⟩ How many categories of Data Types in Oracle?
Oracles supports the following categories of data types:
* Oracle Built-in Datatypes.
* ANSI, DB2, and SQL/DS Datatypes.
* User-Defined Types.
* Oracle-Supplied Types.
Oracles supports the following categories of data types:
* Oracle Built-in Datatypes.
* ANSI, DB2, and SQL/DS Datatypes.
* User-Defined Types.
* Oracle-Supplied Types.
What is latest version of Power Center / Power Mart?
What is the difference between Power Center & Power Mart?
What are the various transformation available?
What is ODS (operation data source)?
What is the difference between etl tool and olap tools?
What is the metadata extension?
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?
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?
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
What is Full load & Incremental or Refresh load?