Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is tracing level and what are the types?

619

Can there be sub steps of etl steps?

600

What are the etl testing operations includes?

677

What are the various tools used in etl?

639

What is partitioning? Explain different types of partitioning?

751

What do you understand by active and passive transformations?

620

What are the names of the layers in etl?

615

What are the different etl testing categories as per their function?

628

how many steps are there in etl process?

625

What is meant by incremental load?

679

Compare etl & elt?

660

What dedup-component and replicate component does?

850

What the difference between “look-up” file and “look is up” in abinitio?

944

What is the role of co-operating system in abinitio?

1019

What is a look-up?

752


Un-Answered Questions { Data Warehouse }

What is the way to execute pl/sql script using informatica mapping?

1081


Define slowly changing dimensions (SCD)?

714


What is data stream and data adapter is it same are different?

643


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4170


What is a joiner transformation and why it is an active one?

653






Give some examples where proc report’s defaults are same as proc print’s defaults?

761


how do u set partition points in the mapping?

1873


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1955


What is the difference between metadata and data dictionary?

679


What is the functional & architectural differences between business objects and web intelligence reports?

663


How create measures and demensions?

710


Explain security filter?

693


Difference between flat files and relational sources?

1847


What does proc print, and proc contents are used for?

703


What is the flow of loading data into fact & dimensional tables?

687