how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer / chintan thakkar
It should always be done at SQ level, that will improve the performance of the mapping since informatica stores a cache for aggregator transformation.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the three tiers in etl?
Explain about hash partitioning?
what is the difference between OLTP database and data warehousing database?
what are the data modeling tools you have used?(polaris)
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Explain about the data integration suite features?
how do use session mapping parameters ?(in which transformation)
without using ETL tool can u prepare a Data warehousing and maintaining?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
what is data modeling?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
where is the cache (lookup, index) created and how can you see it.