What are the performance considerations when working with aggregator transformation?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
How to generate or load values in to the target table based on a column value using informatica etl tool.
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
Quickly characterize reusable change?
What are the ETL tools available in DWH?
In a sequential batch can u run the session if previous session fails?
how do u move the code from development to production?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
How big was your fact table
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
if i am having 10 records in source, i want 20 records in target...how will you do it
what is mapping parameter?