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 |
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
what is index?how it can work in informatica
What are the different lookup cache(s)?
what is metadata?
How you prepared reports for OLAP?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
How to get EVEN & ODD numbers separately?
What are the informatica performance improvement tips
In informatica workflow manager, how many repositories can be created?
Enlist the tasks for which source qualifier transformation is used.
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
Explain why we use partitioning the session in informatica?