Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Analyst
  3. Library Workspace
  4. Connections Workspace
  5. Job Status Workspace
  6. Projects Workspace
  7. Model Repository
  8. Data Objects
  9. Search
  10. Appendix A: Configure the Web Browser

Analyst Tool Guide

Analyst Tool Guide

Flat File Data Types

Flat File Data Types

Configure data types for the data in each column in the
Add Flat File
wizard. The data types you configure determine how the wizard imports the data from the source flat file.
Configure the following data types:
  • Bigint. You can specify the format in the
    Numeric Format
    window. You can use the default or specify another numeric format and choose to make this the default numeric format.
  • Datetime. You can specify the format in the
    Datetime Format
    window. You can use the default or specify another datetime format and choose to make this the default datetime format.
  • Double. You can specify the format in the
    Numeric Format
    window. You can use the default or specify another numeric format and choose to make this the default numeric format.
  • Int. You can specify the format in the
    Numeric Format
    window. You can use the default or specify another numeric format and choose to make this the default numeric format.
  • Nstring. You can specify a value for precision. You cannot specify a format.
  • Number. You can specify values for precision and scale. You can specify the format in the
    Numeric Format
    window. You can use the default or specify another numeric format and choose to make this the default numeric format.
  • String. You can specify a value for precision. You cannot specify a format.

0 COMMENTS

We’d like to hear from you!