Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Added features in Informatica 6.x 2
- Thread starter Sasaya
- Start date
daxeshmaniar
Programmer
Hi,
The major changes in both versions are given below.
1. Support to Teradata : The major changes are that 6.x supports teradata ETL process.
2. Creation of Flat file at the target : This is one of the major features of Informatica and now you can have flat file as target.
This is very very helpful in case when there is a problem in loading the data in the target table, we can check the problem by creating the flat file and getting the data in the same and we can narrow down the scope of the problem.
There are many other features.
I can be reached at daxesh_maniar@yahoo.com
The major changes in both versions are given below.
1. Support to Teradata : The major changes are that 6.x supports teradata ETL process.
2. Creation of Flat file at the target : This is one of the major features of Informatica and now you can have flat file as target.
This is very very helpful in case when there is a problem in loading the data in the target table, we can check the problem by creating the flat file and getting the data in the same and we can narrow down the scope of the problem.
There are many other features.
I can be reached at daxesh_maniar@yahoo.com
-
2
- #3
raj4Informatica
Technical User
Sri,
Can u please elaborate me of creating the text file as target on version 5.0, as I tried to explore on Informatica version 5.0, but could not find.
Raj
Can u please elaborate me of creating the text file as target on version 5.0, as I tried to explore on Informatica version 5.0, but could not find.
Raj
Raj,
Not sure 'bout 5.0 but this is how one do in 5.1
In the Designer create the Target Table with all the necessary columns and there you will not have the option to specify that it is a flat file instead select one DB in the Create Dialog Box. You specify the target as file only during the Session Creation. In the Session Target Options choose File instead of Relational and you can customize the file whether it is Delimited or Fixed Width, File Name etc.
Drop a note if you need further assistance.
Sri
Not sure 'bout 5.0 but this is how one do in 5.1
In the Designer create the Target Table with all the necessary columns and there you will not have the option to specify that it is a flat file instead select one DB in the Create Dialog Box. You specify the target as file only during the Session Creation. In the Session Target Options choose File instead of Relational and you can customize the file whether it is Delimited or Fixed Width, File Name etc.
Drop a note if you need further assistance.
Sri
raj4Informatica
Technical User
Hi Sri,
Thanks for your clarification, Actually I do have version 5.1 not 5, so i did try to write to a flat file and it worked. As I am new to DWH and now a days learning Inforamtica on my own, so sometime I might ask foolish questions also, Please bear with me.
One more thing which got me confused that in the release note of Informatica version 6.2, it has been mentioned that Writing to a flat file is the new enhancement but inndeed it not new feature but enhanced feature, as release note does not clearly distinguish between the new feature and enhanced feature.
ThankU-2-2-2
Raj
Thanks for your clarification, Actually I do have version 5.1 not 5, so i did try to write to a flat file and it worked. As I am new to DWH and now a days learning Inforamtica on my own, so sometime I might ask foolish questions also, Please bear with me.
One more thing which got me confused that in the release note of Informatica version 6.2, it has been mentioned that Writing to a flat file is the new enhancement but inndeed it not new feature but enhanced feature, as release note does not clearly distinguish between the new feature and enhanced feature.
ThankU-2-2-2
Raj
Raj,
Infact they have only one section for New Features and Enhancements in 6.0 manuals and haven't specified which is a enhancement and new features. But as far as Flat File is concerned it is indeed a new feature in Designer where you can Create Flat File Target just like one does Flat File Sources. This was not there in earlier version where one is confined to create the Table for one DB and then specifying the target only during Session.
In the Workflow Manager it can be taken as an Enhancement since it allows to use Flat File Definition or Relation Table Definition for writing to Flat File Targets.
HTH
Sri
Infact they have only one section for New Features and Enhancements in 6.0 manuals and haven't specified which is a enhancement and new features. But as far as Flat File is concerned it is indeed a new feature in Designer where you can Create Flat File Target just like one does Flat File Sources. This was not there in earlier version where one is confined to create the Table for one DB and then specifying the target only during Session.
In the Workflow Manager it can be taken as an Enhancement since it allows to use Flat File Definition or Relation Table Definition for writing to Flat File Targets.
HTH
Sri
- Status
Similar threads
- Locked
- Question
- Locked
- Question