top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Whats the benifit of creating table definition manually in informatica (Source Analyzer) instead of importing [CLOSED]

+2 votes
6,361 views

For importing source/target tables, we can either go for importing them from DB/Flat Files/XML Files OR creating the table definition in informatica itself. I have couple of questions here -
•Whats the benifit of creating table definition manuallu in informatica over importing?
•How can we connect that created table definition to the corresponding data source which could be a DB/Flat file/XML etc.
•Please give a scenario where we create table definitions in informatica rather than importing.

Appreciate your interest.

posted Apr 17, 2014 by Madhavi Kumari

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
The only time I modify a definition manually is when I need to make changes to an existing source AND the name of the connection is different than Owner name property of the source definition.

In that case, if you re-import the source object, a new definition will be created in PowerCenter instead of overwriting the existing one. This means that one would have to open all the mappings that use this source and manually replace the old definition with the new one.

1 Answer

+1 vote

1.There are no "benefits" - I guess it's only an option when you've got the definition, but not the sample. E.g. database object have not been created yet, or are not yet accessible, yet you're starting development already.
2.But the only useful scenario I know is editing - it's far quicker to edit source than import the source if you need to change just length or naming of one column.
3.IMPORTANT NOTE: Source definitions are never connected to any single source instance. This is to represent a structure that will be accessed in future without pointing to any specific table, database, or even server.

answer Apr 18, 2014 by Shweta Singh
...