CODEWITHSUNDEEP
informaticainformatica-powercenter
Raja Reddy
Raja Reddy

Reputation: 782

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

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 -

Appreciate your interest.

Upvotes: 0

Views: 1974

Answers (2)

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17333

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.

Upvotes: 1

Maciejg
Maciejg

Reputation: 3353

  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.

Upvotes: 1

Related Questions