If you done any modifications for a table in back end does
it reflect in informatca warehouse or maping?

Answer Posted / deepak aggarwal

No there is no option in informatica for automatic update
of source/target/lookup/stored procedure definition from
DB/file.
Though you can compare source/target/../.. definitions from
existing DB objects and make out if informatica definitions
needs a updation.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load last n records of file into target table - informatica

588


What are active transformations.

1177


What is parallel processing in informatica?

1015


What is native users?

711


What is olap (on-line analytical processing?

628






Which means the first record should come as last record and last record should come as first record and load into the target file?

599


Design a mapping to load a target table with the following values from the above source?

866


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1324


How do you migrate data from one environment to another?

634


What is session task and command task?

637


How many ways are there to create ports?

711


Clarify the utilization of aggregator cache record?

566


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

542


Where is metadata stored?

612


In development project what is the process to follow for an etl developer from day1

1268