Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
1264Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
1248Post New Informatica Questions
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is intricate mapping?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Where are the source flat files kept before running the session?
Explain sql transformation in script mode examples in informatica
What is the function of aggregator transformation?
What is Session and Batches?
What are some examples of informatica etl programs?
What are the reusable transformations?
In informatics server which files are created during the session rums?
What is the maplet?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the static cache and dynamic cache in informatica?
Differentiate between Load Manager and DTM?