how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer Posted / 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 |
Post New Answer View All Answers
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are the etl testing operations includes?
Explain what is etl process? How many steps etl contains explain with example?
what is Forward,Reverse and Re_engineering?
What are the ETL Testing Operations?
What is a lookup table in etl?
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)
List few etl bugs?
What is partitioning? Explain about round-robin, hash partitioning.
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
what is Forward,Reverse and Re_engineering?
What do you understand by active and passive transformations?
how to connect to a flatfile through ftp in informatica
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is the difference between project backlog and product backlog?