Custom Properties in Informatica

Custom Properties in Informatica:-

I have faced a lot of issue in my project
Below is the link

http://www.cifconsult.com/?p=743

What is domain,Administration Server ,Managed Server and Node Manager

What is domain in WebLogic ?

Domain is logical grouping of resources and services and consist of Administration Server, Managed Server and cluster.  There can only be one administration Server in domain and zero to N Managed Server.

What is Administration Server ?

Administration Server is WebLogic Server instance that maintains configuration data for a domain. You can deploy your application on administration Server but it is recommended to create managed Server and deploy your application in managed server and leave Administration domain for configuration and maintenance.

—There will always be atleast one Administration Server in a domain.

What is Managed Server ?

Any WebLogic Server instance apart from Administration Server is called asManaged Servers. This is weblogic server where you deploy your application (Though you can deploy your application in Administration server as well but it is not recommended in production/UAT instance)

What is Cluster in WebLogic ?

Group of WebLogic Managed Server Instances that work together to provide high availability and scalability for applications is called cluster. WebLogic Servers with in cluster can run on same machine or different machines. These are also called as managed Server cluster.

Start WebLogic Domain

Once you have successfully created domain, next step is to  start weblogic domain and access Administration Console. (Steps here are to start basic domain – only one Administration Server,  “Start/Stop WebLogic Server - Administration and Managed Server“

Startup Script$BEA_HOME/user_projects/domain//bin/startWebLogic.sh (Unix)
$BEA_HOME\user_projects\domain\\bin\startWebLogic.cmd(Windows)

I installed domain with name base_domain and my BEA_HOME is c:\bea hence to start my domain -
c:\bea\user_projects\ domains\ base_domain\ bin\ startWebLogic.cmd

Node Manager is Weblogic Server utility to start, stop and restartAdministration and Managed Server Instances from remote location.

1. Node Manager Process is associated with a Machine and NOT with specific Weblogic Domain (i.e. Use one node manager for multiple domains on same machine)

2. There are two versions of Node Manager - Java-based and Script-based

Java-based node manager – runs with in JVM (Java Virtual Machine) Process and more secure than script-based node manager. Configuration for java-based node manager are stored in nodemanager.properties

Script-based node manager – is available for Linux and Unix systems only and is based on shell script.

3. There are multiple ways to access Node Manager
- From Administration Console : Environments -> Machines -> Configuration -> Node Manager
- JMX utilities (Java Management eXtension)
- WLST commands (WebLogic Scripting Tool)

Installation of LOOKBACK ADAPTER on windows x86 platform (64 bit)

On Windows systems, install a loopback adapter on the single DHCP host that obtains an IP address from the DHCP server. This assigns a local IP address to your computer.

After installing the adapter, add a line to the %SYSTEMROOT%\system32\drivers\etc\hosts file with the following format, immediately after the localhost line:

IP_address   hostname.domainname   hostname

Replace IP_address with the local IP address of the loopback adapter.

Installing a Windows Loopback Adapter

To install a loopback adapter on Windows 2003 or Windows XP:

1. Open the Windows Control Panel.

Windows 2003: Select Start > Control Panel > Add Hardware.

Windows XP: Select Start > Control Panel, then double-click Add Hardware.

2. In the "Welcome" window, click Next.
3. In the "Is the hardware connected?" window, select Yes, I have already connected the hardware, then click Next.
4. In the "The following hardware is already installed on your computer" window, in the list of installed hardware, select Add a new hardware device, then click Next.
5. In the "The wizard can help you install other hardware" window, select Install the hardware that I manually select from a list, then click Next.
6. In the "From the list of hardware types, select the type of hardware you are installing" window, select Network adapters, then click Next.
7. In the "Select Network Adapter" window, make the following selections:
• Manufacturer: Microsoft
• Network Adapter: Microsoft Loopback Adapter
8. Click Next.
9. In the "The wizard is ready to install your hardware" window, click Next.
10. In the "Completing the Add Hardware Wizard" window, click Finish.
11. If you are using Windows 2003, restart your computer.
12. Right-click My Network Places on the desktop and choose Properties. This displays the Network Connections Control Panel.
13. Right-click the connection that was just created. This is usually named "Local Area Connection 2". Choose Properties.
14. On the "General" tab, select Internet Protocol (TCP/IP), then click Properties.
15. In the "Properties" dialog box, click Use the following IP address and do the following:

1. IP Address: Enter a non-routable IP for the loopback adapter. Oracle recommends the following non-routable addresses:

b.  192.168.x.x (x is any value between 1 and 255)

c.  10.10.10.10

4. Subnet mask: Enter 255.255.255.0.
5. Record the values you entered, which you will need later in this procedure.
6. Leave all other fields empty.
7. Click OK.
15. In the "Local Area Connection 2 Properties" dialog, click OK.
16. Close Network Connections.
17. Restart the computer.

Removing a Windows Loopback Adapter

To remove a loopback adapter on Windows 2003 or Windows XP:

1. Start the System Control panel.

Windows 2003: Select Start > Control Panel > System.

Windows XP: Select Start > Control Panel, then double-click System.

2. In the "Hardware" tab, click Device Manager.
3. In the "Device Manager" window, expand Network adapters. You should see Microsoft Loopback Adapter.
4. Right-click Microsoft Loopback Adapter and select Uninstall.
5. Click OK.

INFORMATICA SCENARIOS BASED QUESTIONS

INFORMATICA SCENARIOS BASED QUESTIONS

http://dwhlaureate.blogspot.in/2013/02/informatica-scenarios-based-questions.html

Materialized Views

Materialized Views

Materialized views are disk based and update periodically base upon the query definition.

Views are virtual only and run the query definition each time they are accessed.

Materialized views can only be set to refresh automatically through the database detecting changes when

the view query is considered simple by the compiler. If it's considered too complex,

it won't be able to set up what are essentially internal triggers to track changes in the source tables

to only update the changed rows in the mview table.

When you create a materialized view, you'll find that Oracle creates both the mview and as a table

with the same name, which can make things confusing.

Why Use Materialized Views?

You can use materialized views to achieve one or more of the following goals:

1.Ease Network Loads.

2.Create a Mass Deployment Environment.

3.Enable Data Subsetting.

4.Enable Disconnected Computing.

EQ-

create MATERIALIZED  view user1

refresh complete 

START WITH SYSDATE

NEXT SYSDATE + 1

as select DISPLAY_NAME,OFFICE from wc_user_info_test1;

NOTE:-This MV is start from sysdate and next triggered fire for refresh is next day(sysdate+1).

-- First time refresh that is a complete refresh

SQL> BEGIN

2 dbms_mview.REFRESH('mv_test');

3 END;

4 /

PL/SQL procedure successfully completed.

SQL> SELECT last_refresh_type, to_char(last_refresh_date, 'hh24:mi:ss')

2 FROM user_mviews

3 WHERE mview_name = 'MV_TEST';

LAST_REFRESH_TYPE TO_CHAR(LAST_REFRESH_DAT

------------------------ ------------------------

FAST_PCT 21:13:34

Read-Only Materialized Views

CREATE MATERIALIZED VIEW hr.employees AS

SELECT * FROM hr.employees@orc1.world;

Updatable Materialized Views

CREATE MATERIALIZED VIEW hr.departments FOR UPDATE AS

SELECT * FROM hr.departments@orc1.world;

Hierarchies (Level-based hierarchy) in OBIEE 11G

Hierarchies (Level-based hierarchy) in OBIEE 11G

http://sunnyobi.blogspot.in/2013/05/hierarchies-level-based-hierarchies-in.html

OBIEE Architecture

OBIEE  Architecture

1)A Request is made by the users through answer and send it into Presentation server.
2)Presentation server convert request into Logical SQL and send it to Oracle BI Server.
3)Oracle BI Server  Convert Logical to Physical SQL and send it to database.
4)Now result get back to you.

Thanks

OBIEE Directory Structure

OBIEE Directory Structure

difference between obiee 10g and 11g

Some important points/enhancements in OBIEE 11g when compared to OBIEE 10g are listed below

1. OBIEE 11g uses WebLogic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g.
2. The clustering process in much easier and automated in OBIEE 11g.
3. We can now model lookup tables in the repository.
4. The new UI called Unified Framework now combines Answers, Dashboards, and Delivers.
5. A new column called the hierarchical column in introduced.
6. BI Publishers is fully and seamlessly integrated with OBIEE 11g.
7. New time series functions PERIOD ROLLING and AGGREGATE AT are introduced.
8. In OBIEE 11g we can create KPIs to represent business metrics.
9. The aggregate persistence wizard creates indexes automatically.
10. The session variables get initialized when they are actually used in OBIEE 11g unlike OBIEE 10g where they were initialized as soon as a user logs in.
11. OBIEE 11g now supports Ragged (Unbalanced) and Skipped Hierarchy.
12. You can also define Parent-Child hierarchy in OBIEE 11g as well.
13. SELECT_PHYSICAL command is supported in OBIEE 11g.

In OBIEE 11g there are some changes in the terminology as well.

• iBots are renamed as Agents.
• Requests are renamed as Analyses.
• Charts are renamed as Graphs.
• Presentation Columns are renamed as Attribute Columns.

Managed Weblogic Server

A domain is the basic administration unit for WebLogic Server instances. A domain consists of one or more WebLogic Server instances (and their associated resources such as JDBC resource or JMS resource) that can be managed with a single Administration Server.

A minimal domain can contain only one WebLogic Server instance, which functions both as an Administration Server, and as a Managed server. This instance is called as Weblogic Administration Server or Weblogic Admin Sever.

As it is the only instance present in domain so this Weblogic Admin Server can also be used as Managed Weblogic Server.

WEBLOGIC ADMIN SERVER OR WEBLOGIC ADMINISTRATION SERVER:

The minimum requirement for a Weblogic Domain to exist is that it must contain one Administration Server. This Weblogic Server Instance is basically used for the Administrative purpose of complete Weblogic domain.

This Admin Server can also be used for the purpose of deployment of applications along with Administrative purpose and in that case the Admin Server is acting as Managed Weblogic Server instance.

MANAGED WEBLOGIC SERVER:

Any other server instance other than Administrative Server of a Weblogic domain is called as Managed Weblogic Server. Managed Servers host the components and associated resources that constitute the applications—for example, JSPs and EJBs.

Node Manager ?

Node Manager

Oracle Business Intelligence runs within Oracle WebLogic Server, and therefore Oracle WebLogic Administration Server must be started before Oracle Business Intelligence components can be started and maintained.

To start the Oracle Business Intelligence system, you start:

• the Node Manager(It is by default windows service in Enterprise Installation of OBIEE 11G)
• the Administration Server (It is weblogic Admin Server)
• the Managed Servers(Comes with Enterprise Installation of OBIEE 11G)
• and then you start the system components.(All OBIEE Components : BI Server,Presentation Server,Schedular,Java Host,Cluster Services.

Steps involved to start Weblogic node manager and OBIEE11g is as follows.

In order to start all the services your Oracle database need to be up and running.

Start Weblogic Node Manager

run the below tag in command prompt.

ORACLE_BIEE_HOME/wlserver_10.3/server/bin/startNodeManager.cmd

Steps to Manually Start Oracle BIEE 11g

Run the following commands in command prompt
1. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/startWebLogic.cmd

2. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.cmdbi_server1

3. ORACLE_BIEE_HOME/instances/instance1/bin/opmnctl startall

Steps to Manually Stop Oracle BIEE 11g

Run the following commands in command prompt
1. ORACLE_BIEE_HOME/instances/instance1/bin/opmnctl shutdown

2. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.cmdbi_server1

3.ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/stopWebLogic.cmd