How to add constraint on table?

After creating student_target table, if we want
to make studentno as primary key then add constraint
on that.

ALTER TABLE STUDENT_TARGET ADD CONSTRAINT STUDENT_PK PRIMARY KEY (STUDENTNO)

here STUDENT_PK is the constraint name

Informatica not able to load on a table having index?

Assume your target is Oracle, and your table has primary key and index.

When we try to insert data from informatica to table, Informatica gets
Oracle error saying that index exists on the table not able to load.

If you then try to drop the index Oracle doesnt allow you drop
index created on primary key.

To come out from this problem
Way 1:
==================================
In this case , we need to disable informatica Bulk load option

we can see this option in Task properties window (double click task) -> Mapping
tab . and then select target table from left panel. we will see target load
type

Way 2:
=====================================
Disable Parallel load option from oracle
connection. we can see this options when
creating connection in workflow manager

what is the codepage in informatica?

The codepage is an character encoding scheme used by services or tools in informatica



Repository Service codepage:
The Repository Service uses the character set encoded in the repository code page when writing data to the repository. You cannot change the code page in the Repository Service properties after you create the Repository Service.

Metadata Manager repository code page:
The Metadata Manager Service and Metadata Manager application use the character set encoded in the repository code page when writing data to the Metadata Manager repository.

ex: Codepage: MS Windows Latin 1 (ANSI), superset of Latin1

what is the defaulrt port for informatica adminconsole?

By default it uses 6001. we can configure this port either while installation or
by modifying server.xml file in informatica home

Ex:
C:\Informatica\PowerCenter8.6.1\server\tomcat\conf


By default URL to access admin console is

http://hostname:6001/adminconsole/

ex: http://avatar:6001/adminconsole/

Explain SMP and MPP systems?

In terms of software, there are two different types of database software: symmetric multiprocessing (SMP) and massively parallel processing (MPP).

An SMP database system is a database system that runs on one or more machines with several identical processors sharing the same disk storage. When an SMP database system runs on more than one machine, it is called a clustered configuration. The database is physically located in a single disk storage system.

Examples of SMP database systems are SQL Server, Oracle, DB/2, Informix, and Sybase.

An MPP database system is a database system that runs on more than one machine where each machine has its own disk storage. The database is physically located in several disk storage systems that are interconnected to each other. An MPP database system is also known as a parallel database system.
Examples of MPP database systems are Teradata, Neoview, Netezza, and DATAllegro.



The machines in SMP and MPP database systems are called nodes.

An MPP database system is faster and more scalable than an SMP database system. In an MPP database system, a table is physically located in several nodes, each with its own storage

what is Real-Time Data Warehouse?

A real-time data warehouse is a data warehouse that is updated (by the ETL) the
moment the transaction happens in the source system.
For example, you can put triggers on the sales transaction table in the source system so that whenever there is a transaction inserted into the database, the trigger fires and sends the new record to the data warehouse as a message. The data warehouse has an active listenerthat captures the message the moment it arrives, cleanses it, DQs it, transforms it, and inserts it into the fact table immediately. I’m talking about a two-second time difference here, between the moment a customer purchased a product on the web site and the moment data is available in the fact table.

what is ODS?

An ODS is a relational, normalized data store containing the transaction data and current values of master data from the OLTP system

An ODS does not store the history of master data such as the customer, store,and product. When the value of the master data in the OLTP system changes, the ODS is
updated accordingly. An ODS integrates data from several OLTP systems. Unlike a data warehouse,an ODS is updatable.

Because an ODS contains integrated data from several OLTP systems, it is an ideal place
to be used for customer support