Identifying the bottlenecks in various components of
Informatica and resolving them.
No Answer is Posted For this Question
Be the First to Post Answer
Explain about hash partitioning?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
What are three tier systems in etl?
what are the facilities provided by OLAP to analytical users?
what is the difference between normal & bulk loading? and which one is recommended ? why?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Explain do we need an etl tool? When do we go for the tools in the market?
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?
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.
how to load the data to fact table?
explain the methodology of Data Warehousing?(Polaries)
how would u estimate the size of Lookup transform data and index cache?