If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

NO. Informatica is not at all concern with back end data base.It displays u all the information
that is to be stored in repository.If want to reflect back end changes to informatica screens,
again u have to import from back end to informatica by valid connection.And u have to replace the existing files with imported files.

Interview Candidate
Sep 21st, 2004
2
3045

Informatica

Answer

Showing Answers 1 - 2 of 2 Answers

vidyanand

Aug 4th, 2006

Yes, It will be reflected once u refresh the mapping once again.

Tapas

Oct 6th, 2007

It does matter if you have SQL override - say in the SQ or in a Lookup, you override the default sql. Then if you make a change to the underlying table in the database that makes the override SQL incorrect for the modified table, the session will fail.
If you change a table - say rename a column that is in the sql override statement, then session will fail. But if you added a column to the underlying table after the last column, then the sql statement in the override will still be valid. If you make change to the size of columns, the sql will still be valid although you may get truncation of data if the database column has larger size (more characters) than the SQ or subsequent transformation.