Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
1085Post New Informatica Questions
What do you mean by channel change?
Explain the different kinds of facts.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is union transformation in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Could you explain what is enterprise data warehouse?
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.
How can we improve session performance in aggregator transformation?
Briefly define a session task?
Which version configuration tool used in ur project?
How many number of sessions can one group in batches?
What are the types of schemas we have in data warehouse.
Which transformation is needed while using the Cobol sources as source definitions?
Clarify the utilization of aggregator cache record?
What is sequence generator transformation in informatica?