Standard datatypes of Informatica

informatica-powercenter informatica
Vicky picture Vicky · Jan 8, 2013 · Viewed 7.4k times · Source

I read somewhere, but i got confused. They asked, Datatypes of informatica. Informatica is tool, not a programming language. So, How informatica has own datatypes. Still if it is available then please let me know.

Also tell me, what are the informatica datatypes?

Answer

Marek Grzenkowicz picture Marek Grzenkowicz · Jan 8, 2013

A datatype is not a concept exclusive to programming languages. Excel is a tool and yet you can set a cell's datatype (called category in Excel) to Number, Date, Percentage and a few others.

Different transformations support different datatypes, but here's a list for an expression:

  • bigint
  • binary
  • date/time
  • decimal
  • double
  • integer
  • nstring
  • ntext
  • real
  • small integer
  • string
  • text

Related questions

Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I …

Read More
How to dynamically give flat file source file name in session properties of informatica?

i have an issue where i get flat file with date and time extension to flat file name like test_28-10-2012.txt I can get the flat file name in mapping through checking the AddCurrentlyProcessedFileNameproperty in Source Analyzer,from …

Read More
Difference between Joiner and Union Transformation

I'm new to Informatica....What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

Read More