Do we need an ETL tool? When do we go for the tools in the market?
No Answer is Posted For this Question
Be the First to Post Answer
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
how do use session mapping parameters ?(in which transformation)
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
where is the cache (lookup, index) created and how can you see it.
Explain about power designer data modeling software?
What do you understand by active and passive transformations?
what is different between sequential batch and concurrent batch and which is recommended and why?
List few etl bugs?
how would u estimate the size of Lookup transform data and index cache?
Explain about enterprise scalability and roi of data integration suite?
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 many steps etl contains explain with example?