How to get the first 100 rows from the flat file into the target?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what is the difference between datawarehouse and bi?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is the difference between Datawarehouse and OLAP?
What is source qualifier?
What is the difference between aggregate table and materialized view?
What are the tools available for etl?
Explain where do we use semi and non additive facts?
Where we use surrogate key explain with example?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What is scd1 , scd2 , scd3?
Explain what are the different methods of loading dimension tables?
Explain what is batch and describe about types of batches?