How will you check the bottle necks in informatica? From
where do you start checking?
Answer Posted / krish
hay this is nothing but performance tuning
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
what is size of u r database?
Do you find any difficulty while working with flat files as source and target?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to load last n records of file into target table - informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How would you copy the content of one repository to another repository?
server hot-ws270 is connect to Repository B. What does it mean?
How to update source definition?
tell me 5 session failure in real time how can you solve that in your project?
What is confirmed fact in dataware housing?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How do you use reject loader.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?