If you done any modifications for a table in back end does
it reflect in informatca warehouse or maping?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / janardhan avula
No..it could not reflect in informatica.informatica is one
of the Dynamic ETL tool using this tool we can design the
the data effectively according to business
requirement..database is different..
I though am i correct.
if u want more info mail me at avula.janardhan@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain scd type 3 through mapping.
What is deployemnt groups, Lables, query and dynamic deployment group.
Implementation methodology
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
how will you remove the duplicate records from flat file without using sorter?
what is constraint based loading
wht target override?wht advantages it has compare to target update?
Separate from a database, an information bazaar, and an information stockroom?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
how to get the only updated records in the target
What is the role of informatica in project ?Like i showed financial projects?
Enlist the differences between database and data warehouse.