Email task and its parameters declarations ??

Email task and its parameters declarations ??

If you want to make it reusable then you have to create a email task else you can directly call from the post session commands.

Email User Name--$PMFailureEmailUser
Email Subject --FAILURE: ''Foldername'' - Session Name: %S failed
Email Text---
Folder Name: %N
Integration Service Name: %v \nWorkflow Name: %W \nSession Name: %S \n %b %i %c \nMapping Name: %M
%l
%r
Target Table Details:%T
Log file: %g

What is the difference between XSd and DTD and Validating a XML against XSD

What is the difference between XSd and DTD ?

Both of them achieve similar goals to define the structure of xml documents.XSd does in the language of xml itself,DTD uses its own language.Xsd is more expressive and dtd is less expressive.XSD allows for extensible schmeas,has namespace support, has content directives,offers tighter integration with the testing tools etc.DTD has none of these features.XSD is newer and DTD is older.DTD is also used to define other types of documents(types other than XML).


Validating a XML against XSD ?

To check the validity of xml,it has to first be well formed.The XML specification has some rules on well-formedness of xml.Once a documents is found to be well formed ,it can be validated against a schema that defined it,the schema can be defined using many schema definitions.The most popular ones are XSD,DTD and RELAX-NG.To validate a program is used.Some IDEs,MS VisualStudio.YOu can also find programs on the net that perform validation of xml files.

Creating a database link (DB link )

Syntax:
Creating a database link

create database link DB_Link connect to "Username" identified by "Password"using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=HOsT string)(Port =
Port number))(CONNECT_DATA=(SID = service ID)))';

creating a synonym :
create or replace synonym synonym1for schmea. synonym1 @DB_Link;

Creating a table:
create table table1 as (select * from table1@db_link)

Oracle Application Express (Apex)

Oracle Application Express (Apex)

It is a HTML Database where the database can be accessed anywhere following the url and credetials apart from this ,the basic repoting and query handling can also be done in apex .
The main basic three components present in apex are
1)Application Builder
1.1)Create Application
1.2)View Application
1.3)Demonstration
1.4)Application Adminstration
1.4.1)In This we can Manage services Activities and apex users as well.
1.5)Import
2)Sql Workshop
2.1)Object Browser
2.1.1)Create objects
2.1.2)Browse objects
2.2 )Sql Commands
2.2.1)Enter Commands
2.3)Sql Scripts
2.3.1)Create
2.3.2)Upload
2.3.3)View
2.3.4)Export
2.3.5)Import
2.4)Query Builder
2.4.1)Create
2.4.2) view
3)Utilities
3.1)DataLoad/Unload
3.1.1)Load
3.1.2)Unload
3.1.3)Repository
3.2)Generate DDL
3.3)Object Reports
3.3.1)Table Reports
3.3.2)Expection Reports
3.3.3)Security Reports
3.3.4)All objects Reports
3.3.5) PL/SQl Reports
3.4)Recycle Bin
3.5)Database Monitor
3.5.1)Sessions
3.5.2)System Statistics
3.5.3)Top SQL
3.5.4)Long Operations
3.6)Apex Views
3.7)Schema Comparisons
3.8)About Database

Steps to start a pmcmd command to run a workflow from informatica server

Steps to start a pmcmd command to run a workflow from informatica server
1. At the command prompt, switch to the directory where the pmcmd executable is located.
By default, the PowerCenter installer installs pmcmd in the \server\bin directory.2. Enter pmcmd followed by the command name and its required options and arguments:
pmcmd command_name [-option1] argument_1 [-option2] argument_2...
if your not pretty sure where the excutable is present or not just type and pmcmd command in your server and check for the message if throws an "command not found"
then check for this file in your home directory(.cshrc_infa) file this file contains
#ident "@(#)local.cshrc 1.2 00/05/01 SMI"umask 022set path=(/bin /usr/bin /usr/ucb /etc .)if ( $?prompt ) then set history=32endif
setenv ODBCHOME /(server name)/app/informatica/pc_server/ODBC5.2setenv ODBCINI $ODBCHOME/odbc.inisetenv INFA_HOME /mounts/infdev/app/informatica/pc_serversetenv DOMAINS_INFA /(servername)/app/informatica/pc_serversetenv ORACLE_HOME /mounts/ora_home/app/oracle/product/10.2.0.3setenv ORACLE_SID infdev
setenv TNS_ADMIN /(mainserver name)/app/oracle/network
setenv PATH ${PATH}:/Mounts/ora_home/app/oracle/product/10.2.0.3/bin:$ODBCHOME/bin:$INFA_HOME/server/binsetenv LD_LIBRARY_PATH $ORACLE_HOME/lib:$ODBCHOME/lib:$INFA_HOME/server/bin

then type csh command and then source your file .csh source .cshrc_infa
and then run pmcmd command
synatx is as follows
pmcmd scheduleworkflow <-serveraddr-s> [host:]portno <<-user-u> username<-uservar-uv> user_env_var> <<-password-p> password<-passwordvar-pv> password_env_var> [<-folder-f> folder] workflow
--------------------------------- pmcmd startworkflow -sv Integartion service name -d domain -u username -p password -f 'folder' workflow name


If you are alreadyin pmcmd prompt then follow the below mentioned steps

The following commands were helpful for pmcmd:
pmcmd>connect -sv Service -d domain -u username -p password
pmcmd>startworkflow -f 'folder' workflow
pmcmd>getworkflowdetails -f 'folder' -rin workflow
pmcmd>gettaskdetails -f 'folder' workflow
pmcmd>stoptask -f 'folder' workflow
pmcmd>getsessionstatistics -f 'folder' workflow
pmcmd>scheduleworkflow -f 'folder' workflow
pmcmd>unscheduleworkflow -f 'folder' workflow
pmcmd>disconnect -sv Service -d domain -u username -p password