What is the sequence generator transformation in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
What if the source is a flat-file?
What is the difference between source qualifier transformations source filter to filter transformation?
Write the different tools in the workflow manager?
What is an expression transformation in informatica?
Explain the types of lookup transformation?
Which is the t/r that builts only single cache memory?
Why filter transformation is an active one?
What are the components of the workflow manager?
If informatica has its scheduler why using third party scheduler?
How can you increase the performance in joiner transformation?
What are the restrictions of union transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?