Difference between Target-based loading and constraint-based loading?
In which scenario did you used pushdown optimization?
What are the issues you have faced in your project? How did you overcome those issues?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
What is the meaning of decode in informatica?
What are the basic needs to join two sources in a source qualifier?
How do you update the records with or without using update strategy?
If we have lookup table in workflow how do you trouble shhot to increase performance?
What is meant by query override?
What is data merging, data cleansing and sampling?
what are the types of facts with Examples?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
What are the tasks that source qualifier performs?