how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer / sajj
If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible
Is This Answer Correct ? | 0 Yes | 0 No |
What are three tier systems in etl?
what are Lookup caches options? Including persistent caches.
what are the facilities provided by data warehouse to analytical users?
how do u set partition points in the mapping?
What do you understand by active and passive transformations?
what is the difference steps for data modeling?
how would u estimate the size of Lookup transform data and index cache?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
What is meant by incremental load?
Eliminating of duplicate records without using dynamic lookups
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?