How can you use an Oracle sequences in Informatica ? You
have an Informatica sequence generator transformation also.
which one is better to use?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
Explain the use lookup tables and Aggregate tables?
Compare etl & elt?
what is pmrep command?
Explain etl mapping sheets?
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
what is the meant by Normalization and de-normalization?
tell me few points when u become TL
how would u estimate the size of Lookup transform data and index cache?
SCD2 will work on only dimension tables as well as fact Table?
what is different between sequential batch and concurrent batch and which is recommended and why?
how many steps are there in etl process?