If we have lookup table in workflow how do you trouble
shhot to increase performance?
Answer Posted / priya
There are 2 ways :
1. Create a persistant cache
2. Add the lookup table in SQ make it outer joined
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the meaning of up gradation of repository?
What are the components of the workflow manager?
What are the databases that informatica can connect to windows?
What do you mean by channel change?
Enlist some properties of sessions.
How you prepared reports for OLAP?
Explain Dataware house architecture .how data flow from intial to end?
Explain the aggregator transformation?
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?
Which transformation is needed while using the Cobol sources as source definitions?
What is different between the data warehouse and data mart?
What are the issues you have faced in your project? How did you overcome those issues?
Can we get 1st record through Informatica(without sequence number).
Explain what is informatica metadata and where is it stored?
hi real timers . iam waiting for ur reply regarding ETL TESTING