Un-Answered Questions { ETL }

what is the meant by Normalization and de-normalization?

2217


explain the methodology of Data Warehousing?(Polaries)

1464


what are the concerns of OLTP and DSS systems?

1947


what is data modeling?

1878


what is the difference steps for data modeling?

2060


what are the data modeling tools you have used?(polaris)

1526


what is the difference between cardinality and Nullability?

2478


what is Forward,Reverse and Re_engineering?

1704


how would u estimate the size of Aggregator transform data and index cache?

1989


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?

2407


how do u really know that paging to disk is happening while u are using a lookup transform?

2027


how do u set partition points in the mapping?

1776


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.

1612


what is pmrep command?

1929


Difference between flat files and relational sources?

1751