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?
how do u really know that paging to disk is happening while u are using a lookup transform?
how do u set partition points in the mapping?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
explain the methodology of Data Warehousing?(Polaries)
what are the concerns of OLTP and DSS systems?
what is data modeling?
what is the difference steps for data modeling?
what is the difference between cardinality and Nullability?
what is Forward,Reverse and Re_engineering?
what is the meant by Normalization and de-normalization?
explain the methodology of Data Warehousing?(Polaries)
what are the concerns of OLTP and DSS systems?
what is data modeling?