Showing posts with label Workflow Manager. Show all posts
Showing posts with label Workflow Manager. Show all posts

Thursday, 6 September 2012

Setting the Date/Time Display Format in Informatica Workflow Manager


Date and time show in Workflow Manager is the one which is in Windows Control Panel of the PowerCenter Client machine.You can modify using the below steps
  • Go to Control Panel
  • Click on Regional Settings
  • Set the date and time

How to assign values for workflow variables in Informatica

Assignment task is used to assign value to workflow variables that we create. Steps to create the Assignment task are listed below. After creating you can assign values using expression. Once a value is assigned to variable, the Integration service uses the assigned value for the variable always.

How to create an Assignment task:
  1. Go to Workflow Designer, click on the Assignment icon on the Tasks OR Click Tasks and then Create. Select Assignment Task as the task type
  2. After entering a name for the Assignment task click Create. Done. This creates an Assignment task to the workflow.
  3. Double-click the Assignment task to open the Edit Task dialog box.
  4. On the Expressions tab click on Add assignment.

     5.Click on the User Defined Variables field.  
     6.Here you can select the variable for which you want to assign a value. 
    7.Click on the Edit button in the Expression field to open the Expression Editor and enter the   value that you want to assign 
    8.Validation can be done by clicking Validate Button 
    9.Click OK.

Wednesday, 5 September 2012

How to use Unix in Informatica? Use of UNIX in Informatica

Hi guys, you may be well aware of Informatica through the posts that I have put before.Now we will see how important is Unix in Informatica.
 
Informatica server can be installed either on  Windows or Unix.When installed on Windows its easy to handle ,but in case of Unix we need to know about the scripts like PMCMD for aborting workflow and scheduling jobs or running workflows etc.

For Example in order to start workflow in command line mode we have to use:
pmcmd StartWorkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
 [<-folder|-f> folder]
[<-recovery|-norecovery>]
[<-paramfile> paramfile]
[<-localparamfile|-lpf> localparamfile]
[<-osprofile|-o> OSUser]
[-wait|-nowait]
[<-runinsname|-rin> runInsName]
Workflow
Also apart from that we can use Unix in many other cases also like
  • To create Paramerter files or some other important files on Informatica
  • For sending emails to users
  • To check flat  files if they are in proper or not
  • Used to delete,insert and update during Pre and Post sessions
Related Posts Plugin for WordPress, Blogger...

ShareThis