Explain and compare etl & manual development?

929

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

1965

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2277

What is meant by incremental load?

1100

where we cannot use sorter Transformation. if we use then we will not get correct data?

2202

what is the meant by Normalization and de-normalization?

2721

What are the names of the layers in etl?

1002

What are the ETL Testing Operations?

1056

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 ?

2124

Is hadoop a etl tool?

955

what is pmrep command?

2443

Explain the use lookup tables and Aggregate tables?

978

Explain do we need an etl tool? When do we go for the tools in the market?

1023

Explain the key challenges that you face while performing etl testing.

1016

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2558