Preface
Informatica Managed File Transfer Welcome Overview
- Managed File Transfer General Features
  - Workflow Automation
  - Ad-Hoc File Transfers and Collaboration
- Getting Started
  - Screen Tips
  - Login
Dashboard
Resources
Workflows
Task Reference
Services Overview
Users
Logs and Reports
Encryption
System
Appendix
Glossary Terms
- AES
- Asymmetric
- Asymmetric Cryptology
- Authentication
- Certificate
- Certificate Authority
- CIDR
- Cipher
- Cryptology
- CSV
- Decryption
- Diffie-Hellman/DSS
- Digital Signature
- DSA
- Element
- Encryption
- Fingerprint
- FTP
- FTPS
- Hash Function
- HTTP
- HTTPS
- ICAP
- Icon
- ISO format
- JCE Service Provider
- JDBC drivers
- JKS
- Key
- Key Alias/Key ID
- Key Pair
- Key Store
- MDN
- MMS
- Non-Repudiation
- Passphrase
- PKCS12
- Private Key
- Project
- Public Key
- Public Key Cryptology
- Public Keyring
- RSA
- Run Priority
- SAML
- Secret Key
- Secret Keyring
- Self-Signed Certificate
- SFTP
- Signing
- SMS
- SMTP
- SSH
- SSL
- SSO
- Symmetric
- Symmetric Cryptology
- URL
- Variable
- Verification
- XML

User Guide

10.2.2
- 10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.1
- 10.2

Back Next

RowSet

variable contains a list of records (rows) that were read from a file or database.

For instance, you may want to read data from an Excel file and then import that data into a database. In the example below, a variable named 'myData' will be created to hold the records read from an Excel file.

The RowSet 'myData' can then be used in a task (for example, SQL Task) that needs to read those records.

When using an input variable within a Project task, it should be formatted as ${variablename}.

The following table illustrates data that is contained in the RowSet variable named 'myData':

${myData} RowSet Variable
${myData[1]}	${myData[2]}	${myData[3]}	${myData[4]}	${myData[5]}	${myData[6]}
Employee ID	First Name	Last Name	Hire Date	Dept. Code	Salary
34594	Heather	Banks	1998-01-19	BB001	72000
34593	Tina	Young	2010-04-01	BB001	65000
34590	Kathy	Harris	2007-09-30	KH001	105000
34592	Mark	Walker	2012-11-15	KH001	87500
34591	John	Davis	2001-06-15	KH001	85000

Informatica Managed File Transfer stores metadata information within the RowSet variable when it is created from a data translation task such as a SQL or Read CSV. The metadata includes:

Column Indexes: Columns in a RowSet variable can be accessed by notating the Index number of the column on the variable name within brackets "[]". All Indexes in RowSet variables begin at Index 1. For example: The variable ${myData[1]} refers to the data from the column at Index 1.
Column Header Names: Columns in a RowSet variable can also be accessed by notating the column's Header name on the variable, also within brackets "[]". For example: The variable ${myData[Salary]} refers to the data from the column at Index 6.
Data Type: When a RowSet is created, each column defaults to the data type VARCHAR. The data type of a column can be later specified using a Column Element of a Data Translation Task. For example: The Salary data type can be updated from VARCHAR (72000) to DECIMAL (72000.00).

Rename Saved Search

Table of Contents

User Guide

User Guide

RowSet

RowSet