interface-development.com

Script Wizard 2.0

murech — Thu, 06 May 2010 16:41:33 +0000

This walkthrough shows how to use Script Wizard in order to create command line scripts for Informatica PowerCenter™.

Walkthrough:

1. Launch Script Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. A new (empty) document is shown. Start typing to create your own script file or open a file by clicking on icon Open.

Tip: Command Reference provides a syntax reference that allows to insert example commands by double-clicking on a command.

Figure 2: Create Script File

3. Click [ Next ] to continue.

4. Specify the output type. Click [ Next ] to continue.

Figure 3: Choose Output File

5. Review the summary window. Click [ Finish ] to execute the wizard.

Figure 4: Completing Script Wizard

Deployment Wizard 1.0

admin — Tue, 20 Apr 2010 11:35:50 +0000

This walkthrough shows how to use Deployment Wizard in order to a create a release note and deployment package.

Walkthrough:
1. Launch Deployment Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. A new (empty) release note is shown.
3. Use the toolbar to add one or more deployment steps.
4. Once done, add deployment objects for each step. You can add the following objects:
database scripts , documents , files or Informatica deployment groups .

5. Add a note object if you want to include some additional text for describing the deployment objects.

Note: You can import an existing deployment package configuration by clicking on icon Open.

Figure 2: Create Deployment Package

6. Click [ Next ] to continue.
7. Specify build location and compression format for the deployment package. Moreover, define a file name if you want to export the deployment package configuration. Click [ Next ] to continue.

Figure 3: Choose Output

8. Review the summary window. Click [ Finish ] to execute the wizard.

Figure 4: Completing Deployment Wizard

Control Wizard 1.0

admin — Tue, 20 Apr 2010 09:55:36 +0000

This walkthrough shows how to use Control Wizard in order to create a deployment or import control file for Informatica PowerCenter™.

Walkthrough:

1. Launch Control Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. Create a new deployment or import control file by clicking on toolbar icon New.

3. The control file is shown. Enter the required information.

Figure 2: Create Control File

4. Click [ Next ] to continue.

5. Specify the location and file name where you want to save the output. Click [ Next ] to continue.

Figure 3: Choose Output File

6. Review the summary window. Click [ Finish ] to execute the transformation.

Figure 4: Completing Control Wizard

Crypto Wizard 1.0

admin — Wed, 31 Mar 2010 10:38:31 +0000

This walkthrough shows how to use Crypto Wizard in order to encrypt and decrypt files and create a key.

Walkthrough:
1. Launch Crypto Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. Select the input files by clicking on icon or simply drag and drop the files into the wizard.
3. Specify the type, cryptography algorithm and key to use for the encryption/ecryption. Click [ Next ] to continue.

Figure 2: Select Input Files

4. Specify the location where you want to encrypt/decrypt the files and the key. Click [ Next ] to continue.

Figure 3: Choose Output File

5. Review the summary window. Click [ Finish ] to execute the wizard.

Figure 4: Completing Crypto Wizard

XML Wizard 2.0

murech — Tue, 30 Mar 2010 15:53:06 +0000

This walkthrough shows how to use XML Wizard in order to maintain the structure and content of XML documents.

Walkthrough:

1. Launch XML Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. A new (empty) document is shown. Start typing to create your own XML document or open a file by clicking on icon Open.

Tip:
If your XML document refers to a DTD document (look for tag: ) you need to place the DTD into the same directory where the XML document is selected from.

3. The XML document will be shown in the Document or Data window.

Figure 2: Create XML Document

4. Click [ Next ] to continue.

5. Specify the location and file name where you want to save the output. Click [ Next ] to continue.

Figure 3: Choose Output File

6. Review the summary window. Click [ Finish ] to execute the wizard.

Figure 4: Completing XML Wizard

XSD Wizard 2.0

murech — Wed, 17 Mar 2010 20:20:16 +0000

This walkthrough shows how to use XSD Wizard in order to convert XML documents into XML Schema Definitions (XSD).

Walkthrough:

1. Launch XSD Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. Select the XML document by either clicking on icon Open to open a dialog or simply drag and drop the XML document into the wizard.

Tip:
If your XML document refers to a DTD document (look for tag: ) you need to place the DTD into the same directory where the XML document is selected from.

3. The data will be shown in the preview window.

Figure 2: Select XML Document

4. Click [ Next ] to continue.

5. Specify the location and file name where you want to save the output. Click [ Next ] to continue.

Figure 3: Choose Output File

6. Review the summary window. Select the checkbox at the bottom if you want to open the output file after the transformation has been done. Click [ Finish ] to execute the transformation.

Figure 4: Completing XSD Wizard

With the given example, XSD Wizard will process the following output:

Figure 5: Output File

Validation Wizard 1.3

murech — Tue, 16 Mar 2010 14:13:56 +0000

This walkthrough shows how to use Validation Wizard in order to validate the content of your data.

Walkthrough:

1. Launch Validation Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. Select the input files by clicking on icon or simply drag and drop the files into the wizard.

3. Specify the hash algorithm to use for the calculation and click [ Next ] to continue.

Figure 2: Select Input Files

4. Specify the location and file name where you want to save the output. Click [ Next ] to continue.

Figure 3: Choose Output File

5. Review the summary window. Click [ Finish ] to execute the wizard.

Figure 4: Completing Validation Wizard

Parameter Wizard 2.1

murech — Fri, 15 Jan 2010 19:25:23 +0000

This walkthrough shows how to use Parameter Wizard in order to create a parameter file for Informatica PowerCenter™.

Walkthrough:

1. Launch Parameter Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. A new (empty) document is shown. Start typing to create your own parameter file or open a file by clicking on icon Open.

Tip: Parameter Types provides a syntax reference that allows to insert example parameters by double-clicking on a parameter or variable.

Figure 2: Create Parameter File

3. Click [ Next ] to continue.

4. Specify the output type. Click [ Next ] to continue.

Figure 3: Choose Output File

5. Review the summary window. Click [ Finish ] to execute the wizard.

Figure 4: Completing Parameter Wizard

SQL Wizard 1.0

murech — Tue, 02 Jun 2009 06:35:20 +0000

This walkthrough shows how to use SQL Wizard in order to create SQL code.

Walkthrough:

1. Launch SQL Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. A new (empty) document is shown. Start typing to create your own SQL code or open a file by clicking on icon .

Tip: SQL Builder provides a syntax reference that allows to insert example SQL code by double-clicking on a SQL command.

Figure 2: Create SQL Code

3. Click [ Next ] to continue.

4. Specify the location and file name where you want to save the output. Click [ Next ] to continue.

Figure 3: Choose Output File

5. Review the summary window. Select the checkbox at the bottom if you want to open the output file after creation. Click [ Finish ] to execute the wizard.

Figure 4: Completing SQL Wizard

XSLT Wizard 2.0

murech — Fri, 29 May 2009 13:30:58 +0000

This walkthrough shows how to use XSLT Wizard in order to tranform XML documents into html format.

Walkthrough:

1. Launch XSLT Wizard and click [ Next ] to continue.

Figure 1: Welcome Screen

2. Select the XML document by either clicking on icon Open to open a dialog or simply drag and drop the XML document into the wizard.

Tip:
If your XML document refers to a DTD document (look for tag: ) you need to place the DTD into the same directory where the XML document is selected from.

3. The data will be shown in the preview window.

Figure 2: Select XML Document

4. Click [ Next ] to continue.

5. Select the XSL stylesheet by either clicking on icon to open a dialog or simply drag and drop the XSL stylesheet into the wizard.

6. The stylesheet will be shown in the preview window. Click [ Next ] to continue.

Figure 3: Select XSL Stylesheet

7. Specify the location and file name where you want to save the output. Click [ Next ] to continue.

Figure 4: Choose Output File

8. Review the summary window. Select the checkbox at the bottom if you want to open the output file after the transformation has been done. Click [ Finish ] to execute the transformation.

Figure 5: Completing XSLT Wizard

With the given example, XSLT Wizard will process the following output:

Figure 6: Output File