Enhancments in informatica 8.6 Version :
- Target from Transformation :In Infa 8 we can create target from transformation by dragging transformation in Target designer
- Pushdown optimization : Uses increased performance by pushing transformation logic to the database by analyzing the transformations and issuing SQL statements to sources and targets. Only processes any transformation logic that it cannot push to the database.
- New function in expression editor :New function have been introduced in informatica 8 like reg_extract and reg_match
- Repository query available in both versioned and non versioned repositories previously it was available only for versioned repository
- UDF (User defined function) similar to macro in excel
- FTP :We can have partitioned FTP targets and Indirect FTP filesource(with file list).
- Propagating Port Descriptions : In Infa 8 we can edit a port description and propagate the description to other transformations in the mapping.
- Environment SQL Enhancements : Environment SQL can still be used to execute an SQL statement at start of connection to the database. We can Use SQL commands that depend upon a transaction being opened during the entire read or write process. For example, the following SQL command modifies how the session handles characters: Alter session set NLS_DATE_FORMAT='DD/MM/YYYY';".
- Concurrently write to multiple files in a session with partitioned targets.
- Flat File Enhancements :
- Reduced conversion of data types
- Delimited file performance has improved
- Flat file now can have integer and double data types
- Data can be appended to existing flat files
No comments:
Post a Comment