If i done any modifications for my table in back end does it
reflect in informatca warehouse or maping desginer or source
analyzer?
Answers were Sorted based on User's Feedback
Answer / swetha
NO. Informatica is not at all concern with back end data
base.It displays you all the information that is to be
stored in repository.If want to reflect back end changes to
informatica screens, again you have to import from back end
to informatica by valid connection.And you have to replace
the existing files with imported files.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / puli ramesh
The Informatica Repositoy will have already an imported
tables and if changes been done at backend is concerned
tables. Untill it is Re-import the tables from the database
then changes will be reflected.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is olap (on-line analytical processing?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
How to extract sap data using informatica?
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
what is the function of 'F10' informatica ?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
in realtime which situations u can use unconnected lookup transformation
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a filter transformation?