Read previous post: Informatica interview questions and answers-2
20. How to make dependency between workflows (which are in different folders) without using any third-party scheduler?
We can use pmcmd command.
Syntax: `pmcmd startworkflow -sv Integration_Service_Name -d Domain_Name –paramfile ‘$PMROOTDIR/PARAM_FILE.TXT’-u User_Name -p Password -f Folder_Name Workflow_Name`
21. Can you explain what is dynamic and static partition at session level?
Read this page for answer.
22. What are the sources you worked on till now?
This is a general question, you can explain this based on your experience.
23. What is the Informatica version you are working currently?
24. Explain the differences between Informatica Power center 9.1 and 10 versions?
25. How can you identify the bottlenecks in the mapping?
Read this page for answer.
26. How can you identify the bottlenecks in the session?How do you resolve the performance issues with the session? it was running less than 10 minutes from the past 1 month and now it took more than 1 hour.
27. How can we call Informatica workflows from third part schedulers?
Using `pmcmd` command.
28. What are the common steps we need to take to optimize a mapping?
Read this page for answer.
29. What are the common steps we need to take to optimize a session?
Read this page for answer.
30. what if we don’t enable lookup cache?
If you enable caching in a Lookup transformation, the Integration Service builds a cache in memory to store lookup data. When the Integration Service builds a lookup cache in memory, it processes the first row of data in the transformation and queries the cache for each row that enters the transformation. If you do not enable caching, the Integration Service queries the lookup source for each input row.
The result of the Lookup query and processing is the same, whether or not you cache the lookup source. However, using a lookup cache can increase session performance. You can optimize performance by caching the lookup source when the source is large.
Next page: Informatica interview questions and answers-4
