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
How to load last n records of file into target table - informatica
What are active transformations.
What is parallel processing in informatica?
What is native users?
What is olap (on-line analytical processing?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Design a mapping to load a target table with the following values from the above source?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How do you migrate data from one environment to another?
What is session task and command task?
How many ways are there to create ports?
Clarify the utilization of aggregator cache record?
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?
Where is metadata stored?
In development project what is the process to follow for an etl developer from day1