What are snapshots? What are materialized views & where do we use them? What is a materialized view log?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,


Explain about power designer data modeling software?

0 Answers  


how to connect to a flatfile through ftp in informatica

1 Answers   TCS,


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,


List few etl bugs?

0 Answers  






how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

0 Answers   Thomson,


what is meant by drill through?(Mascot)

1 Answers  


Explain what are the various etl tools in the market?

0 Answers  


When do we analyze the tables? How do we do it?

0 Answers  


What is virtual Data Warehousing?

0 Answers  


Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  


what are the facilities provided by data warehouse to analytical users?

0 Answers  


Categories